Dataset statistics
| Number of variables | 100 |
|---|---|
| Number of observations | 150346 |
| Missing cells | 10369206 |
| Missing cells (%) | 69.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 114.7 MiB |
| Average record size in memory | 800.0 B |
Variable types
| Categorical | 20 |
|---|---|
| Unsupported | 3 |
| Numeric | 4 |
| Boolean | 73 |
attributes_Music_no_music has constant value "" | Constant |
attributes_DietaryRestrictions_kosher has constant value "" | Constant |
business_id has a high cardinality: 150346 distinct values | High cardinality |
city has a high cardinality: 1416 distinct values | High cardinality |
categories has a high cardinality: 83160 distinct values | High cardinality |
hours_Monday has a high cardinality: 1315 distinct values | High cardinality |
hours_Tuesday has a high cardinality: 1414 distinct values | High cardinality |
hours_Wednesday has a high cardinality: 1403 distinct values | High cardinality |
hours_Thursday has a high cardinality: 1462 distinct values | High cardinality |
hours_Friday has a high cardinality: 1538 distinct values | High cardinality |
hours_Saturday has a high cardinality: 1439 distinct values | High cardinality |
hours_Sunday has a high cardinality: 1291 distinct values | High cardinality |
attributes_BusinessAcceptsCreditCards is highly imbalanced (71.2%) | Imbalance |
attributes_CoatCheck is highly imbalanced (60.3%) | Imbalance |
attributes_RestaurantsTakeOut is highly imbalanced (58.6%) | Imbalance |
attributes_BusinessParking_garage is highly imbalanced (72.4%) | Imbalance |
attributes_BusinessParking_validated is highly imbalanced (92.1%) | Imbalance |
attributes_BusinessParking_valet is highly imbalanced (87.9%) | Imbalance |
attributes_WheelchairAccessible is highly imbalanced (52.7%) | Imbalance |
attributes_RestaurantsAttire is highly imbalanced (89.7%) | Imbalance |
attributes_Ambience_romantic is highly imbalanced (87.5%) | Imbalance |
attributes_Ambience_intimate is highly imbalanced (84.9%) | Imbalance |
attributes_Ambience_touristy is highly imbalanced (93.3%) | Imbalance |
attributes_Ambience_hipster is highly imbalanced (81.4%) | Imbalance |
attributes_Ambience_divey is highly imbalanced (76.5%) | Imbalance |
attributes_Ambience_trendy is highly imbalanced (65.2%) | Imbalance |
attributes_Ambience_upscale is highly imbalanced (91.2%) | Imbalance |
attributes_GoodForMeal_dessert is highly imbalanced (62.1%) | Imbalance |
attributes_GoodForMeal_latenight is highly imbalanced (70.0%) | Imbalance |
attributes_BusinessAcceptsBitcoin is highly imbalanced (82.1%) | Imbalance |
attributes_Music_dj is highly imbalanced (70.1%) | Imbalance |
attributes_Music_background_music is highly imbalanced (81.3%) | Imbalance |
attributes_Music_jukebox is highly imbalanced (60.1%) | Imbalance |
attributes_Music_video is highly imbalanced (97.7%) | Imbalance |
attributes_Music_karaoke is highly imbalanced (90.0%) | Imbalance |
attributes_DietaryRestrictions_halal is highly imbalanced (78.9%) | Imbalance |
attributes_ByAppointmentOnly has 108047 (71.9%) missing values | Missing |
attributes_BusinessAcceptsCreditCards has 30654 (20.4%) missing values | Missing |
hours_Monday has 35872 (23.9%) missing values | Missing |
hours_Tuesday has 29715 (19.8%) missing values | Missing |
hours_Wednesday has 26575 (17.7%) missing values | Missing |
hours_Thursday has 25148 (16.7%) missing values | Missing |
hours_Friday has 25347 (16.9%) missing values | Missing |
hours_Saturday has 39576 (26.3%) missing values | Missing |
attributes_BikeParking has 77788 (51.7%) missing values | Missing |
attributes_RestaurantsPriceRange2 has 65066 (43.3%) missing values | Missing |
attributes_CoatCheck has 144766 (96.3%) missing values | Missing |
attributes_RestaurantsTakeOut has 92594 (61.6%) missing values | Missing |
attributes_RestaurantsDelivery has 98012 (65.2%) missing values | Missing |
attributes_Caters has 110279 (73.4%) missing values | Missing |
attributes_WiFi has 93482 (62.2%) missing values | Missing |
attributes_BusinessParking_garage has 63461 (42.2%) missing values | Missing |
attributes_BusinessParking_street has 64872 (43.1%) missing values | Missing |
attributes_BusinessParking_validated has 63692 (42.4%) missing values | Missing |
attributes_BusinessParking_lot has 63830 (42.5%) missing values | Missing |
attributes_BusinessParking_valet has 61551 (40.9%) missing values | Missing |
attributes_WheelchairAccessible has 121420 (80.8%) missing values | Missing |
attributes_HappyHour has 135177 (89.9%) missing values | Missing |
attributes_OutdoorSeating has 103426 (68.8%) missing values | Missing |
attributes_HasTV has 105281 (70.0%) missing values | Missing |
attributes_RestaurantsReservations has 105387 (70.1%) missing values | Missing |
attributes_DogsAllowed has 132088 (87.9%) missing values | Missing |
hours_Sunday has 69174 (46.0%) missing values | Missing |
attributes_Alcohol has 107195 (71.3%) missing values | Missing |
attributes_GoodForKids has 96999 (64.5%) missing values | Missing |
attributes_RestaurantsAttire has 111129 (73.9%) missing values | Missing |
attributes_RestaurantsTableService has 130379 (86.7%) missing values | Missing |
attributes_RestaurantsGoodForGroups has 106197 (70.6%) missing values | Missing |
attributes_DriveThru has 143341 (95.3%) missing values | Missing |
attributes_NoiseLevel has 112392 (74.8%) missing values | Missing |
attributes_Ambience_romantic has 109954 (73.1%) missing values | Missing |
attributes_Ambience_intimate has 110860 (73.7%) missing values | Missing |
attributes_Ambience_touristy has 110265 (73.3%) missing values | Missing |
attributes_Ambience_hipster has 111021 (73.8%) missing values | Missing |
attributes_Ambience_divey has 112075 (74.5%) missing values | Missing |
attributes_Ambience_classy has 110211 (73.3%) missing values | Missing |
attributes_Ambience_trendy has 111945 (74.5%) missing values | Missing |
attributes_Ambience_upscale has 109534 (72.9%) missing values | Missing |
attributes_Ambience_casual has 108832 (72.4%) missing values | Missing |
attributes_GoodForMeal_dessert has 126155 (83.9%) missing values | Missing |
attributes_GoodForMeal_latenight has 125306 (83.3%) missing values | Missing |
attributes_GoodForMeal_lunch has 123957 (82.4%) missing values | Missing |
attributes_GoodForMeal_dinner has 122914 (81.8%) missing values | Missing |
attributes_GoodForMeal_brunch has 125160 (83.2%) missing values | Missing |
attributes_GoodForMeal_breakfast has 124021 (82.5%) missing values | Missing |
attributes_BusinessAcceptsBitcoin has 132919 (88.4%) missing values | Missing |
attributes_Smoking has 145793 (97.0%) missing values | Missing |
attributes_Music_dj has 143632 (95.5%) missing values | Missing |
attributes_Music_background_music has 143278 (95.3%) missing values | Missing |
attributes_Music_no_music has 143488 (95.4%) missing values | Missing |
attributes_Music_jukebox has 144158 (95.9%) missing values | Missing |
attributes_Music_live has 143613 (95.5%) missing values | Missing |
attributes_Music_video has 143276 (95.3%) missing values | Missing |
attributes_Music_karaoke has 144556 (96.1%) missing values | Missing |
attributes_GoodForDancing has 145718 (96.9%) missing values | Missing |
attributes_AcceptsInsurance has 144641 (96.2%) missing values | Missing |
attributes_BestNights_monday has 144663 (96.2%) missing values | Missing |
attributes_BestNights_tuesday has 144663 (96.2%) missing values | Missing |
attributes_BestNights_friday has 144663 (96.2%) missing values | Missing |
attributes_BestNights_wednesday has 144663 (96.2%) missing values | Missing |
attributes_BestNights_thursday has 144663 (96.2%) missing values | Missing |
attributes_BestNights_sunday has 144663 (96.2%) missing values | Missing |
attributes_BestNights_saturday has 144663 (96.2%) missing values | Missing |
attributes_BYOB has 145907 (97.0%) missing values | Missing |
attributes_Corkage has 146804 (97.6%) missing values | Missing |
attributes_BYOBCorkage has 148907 (99.0%) missing values | Missing |
attributes_HairSpecializesIn_straightperms has 149344 (99.3%) missing values | Missing |
attributes_HairSpecializesIn_coloring has 149311 (99.3%) missing values | Missing |
attributes_HairSpecializesIn_extensions has 149311 (99.3%) missing values | Missing |
attributes_HairSpecializesIn_africanamerican has 149344 (99.3%) missing values | Missing |
attributes_HairSpecializesIn_curly has 149311 (99.3%) missing values | Missing |
attributes_HairSpecializesIn_kids has 149311 (99.3%) missing values | Missing |
attributes_HairSpecializesIn_perms has 149311 (99.3%) missing values | Missing |
attributes_HairSpecializesIn_asian has 149344 (99.3%) missing values | Missing |
attributes_Open24Hours has 150307 (> 99.9%) missing values | Missing |
attributes_RestaurantsCounterService has 150327 (> 99.9%) missing values | Missing |
attributes_AgesAllowed has 150217 (99.9%) missing values | Missing |
attributes_DietaryRestrictions_dairy-free has 150316 (> 99.9%) missing values | Missing |
attributes_DietaryRestrictions_gluten-free has 150316 (> 99.9%) missing values | Missing |
attributes_DietaryRestrictions_vegan has 150316 (> 99.9%) missing values | Missing |
attributes_DietaryRestrictions_kosher has 150316 (> 99.9%) missing values | Missing |
attributes_DietaryRestrictions_halal has 150316 (> 99.9%) missing values | Missing |
attributes_DietaryRestrictions_soy-free has 150316 (> 99.9%) missing values | Missing |
attributes_DietaryRestrictions_vegetarian has 150316 (> 99.9%) missing values | Missing |
business_id is uniformly distributed | Uniform |
business_id has unique values | Unique |
name is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
address is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
postal_code is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2023-03-07 15:39:21.813749 |
|---|---|
| Analysis finished | 2023-03-07 15:39:50.491767 |
| Duration | 28.68 seconds |
| Software version | ydata-profiling vv4.0.0 |
| Download configuration | config.json |
business_id
Categorical
HIGH CARDINALITY  UNIFORM  UNIQUE 
| Distinct | 150346 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Pns2l4eNsfO8kk83dixA6A | 1 |
|---|---|
| twx6DPOgaD9CN8wlt4Jcbg | 1 |
| ogyKKg_D4ioc6Ech_pKqfw | 1 |
| 9D0aKRGsutg8S0ClIanmrA | 1 |
| _XV_ug_IUiJrGfMiJUqz-Q | 1 |
| Other values (150341) |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
Characters and Unicode
| Total characters | 3307612 |
|---|---|
| Distinct characters | 64 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 150346 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Pns2l4eNsfO8kk83dixA6A |
|---|---|
| 2nd row | mpf3x-BjTdTEA3yCZrAYPw |
| 3rd row | tUFrWirKiKi_TAnsVWINQQ |
| 4th row | MTSW4McQd7CbVtyjqoe9mw |
| 5th row | mWMc6_wTdE0EUBKIGXDVfA |
Common Values
| Value | Count | Frequency (%) |
| Pns2l4eNsfO8kk83dixA6A | 1 | < 0.1% |
| twx6DPOgaD9CN8wlt4Jcbg | 1 | < 0.1% |
| ogyKKg_D4ioc6Ech_pKqfw | 1 | < 0.1% |
| 9D0aKRGsutg8S0ClIanmrA | 1 | < 0.1% |
| _XV_ug_IUiJrGfMiJUqz-Q | 1 | < 0.1% |
| GG4_Idv210PI992wl4Dp_A | 1 | < 0.1% |
| fNBday9iMr-_VOzPDfP_OQ | 1 | < 0.1% |
| glAgJz5nTEhPh67IqyBUZg | 1 | < 0.1% |
| iY3fw3ouBAqglzpjVqQ3DQ | 1 | < 0.1% |
| 9u5_eF46t_8GYd_3xKN5Fw | 1 | < 0.1% |
| Other values (150336) | 150336 |
Length
| Value | Count | Frequency (%) |
| pns2l4ensfo8kk83dixa6a | 1 | < 0.1% |
| jaxmsoinw8poo3xemjt8lq | 1 | < 0.1% |
| w_amnoi1ig9eay7ncmc67w | 1 | < 0.1% |
| roeacjqwbeh05rqg7f6tcg | 1 | < 0.1% |
| 8wgisyjyke2tsqn3cdmu8a | 1 | < 0.1% |
| m0xsshqrasonhgbwdjipqa | 1 | < 0.1% |
| k0hlbqxx-bt0vf1op7jr1w | 1 | < 0.1% |
| tufrwirkiki_tansvwinqq | 1 | < 0.1% |
| mtsw4mcqd7cbvtyjqoe9mw | 1 | < 0.1% |
| mwmc6_wtde0eubkigxdvfa | 1 | < 0.1% |
| Other values (150336) | 150336 |
Most occurring characters
| Value | Count | Frequency (%) |
| w | 87386 | 2.6% |
| Q | 87120 | 2.6% |
| g | 86959 | 2.6% |
| A | 86939 | 2.6% |
| z | 49726 | 1.5% |
| 6 | 49706 | 1.5% |
| 2 | 49695 | 1.5% |
| t | 49689 | 1.5% |
| f | 49630 | 1.5% |
| k | 49626 | 1.5% |
| Other values (54) | 2661136 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1358599 | |
| Uppercase Letter | 1356639 | |
| Decimal Number | 494325 | 14.9% |
| Dash Punctuation | 49048 | 1.5% |
| Connector Punctuation | 49001 | 1.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| w | 87386 | 6.4% |
| g | 86959 | 6.4% |
| z | 49726 | 3.7% |
| t | 49689 | 3.7% |
| f | 49630 | 3.7% |
| k | 49626 | 3.7% |
| d | 49577 | 3.6% |
| x | 49509 | 3.6% |
| e | 49470 | 3.6% |
| h | 49449 | 3.6% |
| Other values (16) | 787578 |
Uppercase Letter
| Value | Count | Frequency (%) |
| Q | 87120 | 6.4% |
| A | 86939 | 6.4% |
| O | 49591 | 3.7% |
| M | 49579 | 3.7% |
| S | 49579 | 3.7% |
| B | 49560 | 3.7% |
| R | 49506 | 3.6% |
| X | 49502 | 3.6% |
| U | 49463 | 3.6% |
| V | 49432 | 3.6% |
| Other values (16) | 786368 |
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 49706 | |
| 2 | 49695 | |
| 7 | 49579 | |
| 0 | 49498 | |
| 1 | 49460 | |
| 9 | 49429 | |
| 3 | 49351 | |
| 4 | 49316 | |
| 5 | 49298 | |
| 8 | 48993 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 49048 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 49001 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2715238 | |
| Common | 592374 | 17.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| w | 87386 | 3.2% |
| Q | 87120 | 3.2% |
| g | 86959 | 3.2% |
| A | 86939 | 3.2% |
| z | 49726 | 1.8% |
| t | 49689 | 1.8% |
| f | 49630 | 1.8% |
| k | 49626 | 1.8% |
| O | 49591 | 1.8% |
| M | 49579 | 1.8% |
| Other values (42) | 2068993 |
Common
| Value | Count | Frequency (%) |
| 6 | 49706 | |
| 2 | 49695 | |
| 7 | 49579 | |
| 0 | 49498 | |
| 1 | 49460 | |
| 9 | 49429 | |
| 3 | 49351 | |
| 4 | 49316 | |
| 5 | 49298 | |
| - | 49048 | |
| Other values (2) | 97994 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3307612 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| w | 87386 | 2.6% |
| Q | 87120 | 2.6% |
| g | 86959 | 2.6% |
| A | 86939 | 2.6% |
| z | 49726 | 1.5% |
| 6 | 49706 | 1.5% |
| 2 | 49695 | 1.5% |
| t | 49689 | 1.5% |
| f | 49630 | 1.5% |
| k | 49626 | 1.5% |
| Other values (54) | 2661136 |
name
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
address
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
city
Categorical
| Distinct | 1416 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Philadelphia | |
|---|---|
| Tucson | 9250 |
| Tampa | 9050 |
| Indianapolis | 7540 |
| Nashville | 6971 |
| Other values (1411) |
Length
| Max length | 52 |
|---|---|
| Median length | 29 |
| Mean length | 9.2428532 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1389626 |
|---|---|
| Distinct characters | 62 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 3 ? |
Unique
| Unique | 590 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | Santa Barbara |
|---|---|
| 2nd row | Affton |
| 3rd row | Tucson |
| 4th row | Philadelphia |
| 5th row | Green Lane |
Common Values
| Value | Count | Frequency (%) |
| Philadelphia | 14569 | 9.7% |
| Tucson | 9250 | 6.2% |
| Tampa | 9050 | 6.0% |
| Indianapolis | 7540 | 5.0% |
| Nashville | 6971 | 4.6% |
| New Orleans | 6209 | 4.1% |
| Reno | 5935 | 3.9% |
| Edmonton | 5054 | 3.4% |
| Saint Louis | 4827 | 3.2% |
| Santa Barbara | 3829 | 2.5% |
| Other values (1406) | 77112 |
Length
| Value | Count | Frequency (%) |
| philadelphia | 14586 | 7.6% |
| tucson | 9273 | 4.8% |
| tampa | 9225 | 4.8% |
| indianapolis | 7548 | 3.9% |
| new | 7334 | 3.8% |
| saint | 7017 | 3.7% |
| nashville | 6987 | 3.7% |
| louis | 6490 | 3.4% |
| orleans | 6217 | 3.2% |
| reno | 5945 | 3.1% |
| Other values (1062) | 110704 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 148933 | 10.7% |
| e | 118641 | 8.5% |
| i | 109094 | 7.9% |
| n | 106165 | 7.6% |
| l | 103560 | 7.5% |
| o | 86646 | 6.2% |
| r | 74166 | 5.3% |
| s | 68576 | 4.9% |
| t | 55713 | 4.0% |
| h | 49379 | 3.6% |
| Other values (52) | 468753 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1153369 | |
| Uppercase Letter | 191803 | 13.8% |
| Space Separator | 41038 | 3.0% |
| Other Punctuation | 3300 | 0.2% |
| Dash Punctuation | 101 | < 0.1% |
| Open Punctuation | 6 | < 0.1% |
| Close Punctuation | 6 | < 0.1% |
| Format | 3 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 148933 | |
| e | 118641 | |
| i | 109094 | |
| n | 106165 | |
| l | 103560 | |
| o | 86646 | 7.5% |
| r | 74166 | 6.4% |
| s | 68576 | 5.9% |
| t | 55713 | 4.8% |
| h | 49379 | 4.3% |
| Other values (16) | 232496 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 24762 | |
| S | 21537 | |
| T | 21152 | |
| N | 16429 | 8.6% |
| B | 13749 | 7.2% |
| C | 11465 | 6.0% |
| L | 10982 | 5.7% |
| R | 8600 | 4.5% |
| M | 8171 | 4.3% |
| I | 8013 | 4.2% |
| Other values (15) | 46943 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2975 | |
| ' | 287 | 8.7% |
| , | 26 | 0.8% |
| & | 10 | 0.3% |
| / | 2 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 41037 | ||
| Â | 1 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 101 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 6 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 6 |
Format
| Value | Count | Frequency (%) |
| ​ | 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1345172 | |
| Common | 44454 | 3.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 148933 | 11.1% |
| e | 118641 | 8.8% |
| i | 109094 | 8.1% |
| n | 106165 | 7.9% |
| l | 103560 | 7.7% |
| o | 86646 | 6.4% |
| r | 74166 | 5.5% |
| s | 68576 | 5.1% |
| t | 55713 | 4.1% |
| h | 49379 | 3.7% |
| Other values (41) | 424299 |
Common
| Value | Count | Frequency (%) |
| 41037 | ||
| . | 2975 | 6.7% |
| ' | 287 | 0.6% |
| - | 101 | 0.2% |
| , | 26 | 0.1% |
| & | 10 | < 0.1% |
| ( | 6 | < 0.1% |
| ) | 6 | < 0.1% |
| ​ | 3 | < 0.1% |
| / | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1389622 | |
| Punctuation | 3 | < 0.1% |
| None | 1 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 148933 | 10.7% |
| e | 118641 | 8.5% |
| i | 109094 | 7.9% |
| n | 106165 | 7.6% |
| l | 103560 | 7.5% |
| o | 86646 | 6.2% |
| r | 74166 | 5.3% |
| s | 68576 | 4.9% |
| t | 55713 | 4.0% |
| h | 49379 | 3.6% |
| Other values (50) | 468749 |
Punctuation
| Value | Count | Frequency (%) |
| ​ | 3 |
None
| Value | Count | Frequency (%) |
| Â | 1 |
state
Categorical
| Distinct | 27 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| PA | |
|---|---|
| FL | |
| TN | |
| IN | |
| MO | |
| Other values (22) |
Length
| Max length | 3 |
|---|---|
| Median length | 2 |
| Mean length | 2.0000067 |
| Min length | 2 |
Characters and Unicode
| Total characters | 300693 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | CA |
|---|---|
| 2nd row | MO |
| 3rd row | AZ |
| 4th row | PA |
| 5th row | PA |
Common Values
| Value | Count | Frequency (%) |
| PA | 34039 | |
| FL | 26330 | |
| TN | 12056 | 8.0% |
| IN | 11247 | 7.5% |
| MO | 10913 | 7.3% |
| LA | 9924 | 6.6% |
| AZ | 9912 | 6.6% |
| NJ | 8536 | 5.7% |
| NV | 7715 | 5.1% |
| AB | 5573 | 3.7% |
| Other values (17) | 14101 |
Length
| Value | Count | Frequency (%) |
| pa | 34039 | |
| fl | 26330 | |
| tn | 12056 | 8.0% |
| in | 11247 | 7.5% |
| mo | 10913 | 7.3% |
| la | 9924 | 6.6% |
| az | 9912 | 6.6% |
| nj | 8536 | 5.7% |
| nv | 7715 | 5.1% |
| ab | 5573 | 3.7% |
| Other values (17) | 14101 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 64655 | |
| N | 39555 | |
| L | 38399 | |
| P | 34039 | |
| F | 26330 | |
| I | 17863 | 5.9% |
| T | 12063 | 4.0% |
| M | 10918 | 3.6% |
| O | 10916 | 3.6% |
| Z | 9912 | 3.3% |
| Other values (11) | 36043 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 300693 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 64655 | |
| N | 39555 | |
| L | 38399 | |
| P | 34039 | |
| F | 26330 | |
| I | 17863 | 5.9% |
| T | 12063 | 4.0% |
| M | 10918 | 3.6% |
| O | 10916 | 3.6% |
| Z | 9912 | 3.3% |
| Other values (11) | 36043 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 300693 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 64655 | |
| N | 39555 | |
| L | 38399 | |
| P | 34039 | |
| F | 26330 | |
| I | 17863 | 5.9% |
| T | 12063 | 4.0% |
| M | 10918 | 3.6% |
| O | 10916 | 3.6% |
| Z | 9912 | 3.3% |
| Other values (11) | 36043 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 300693 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 64655 | |
| N | 39555 | |
| L | 38399 | |
| P | 34039 | |
| F | 26330 | |
| I | 17863 | 5.9% |
| T | 12063 | 4.0% |
| M | 10918 | 3.6% |
| O | 10916 | 3.6% |
| Z | 9912 | 3.3% |
| Other values (11) | 36043 |
postal_code
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
latitude
Real number (ℝ)
| Distinct | 135593 |
|---|---|
| Distinct (%) | 90.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.67115 |
| Minimum | 27.555127 |
|---|---|
| Maximum | 53.679197 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 27.555127 |
|---|---|
| 5-th percentile | 27.895173 |
| Q1 | 32.187293 |
| median | 38.777413 |
| Q3 | 39.954036 |
| 95-th percentile | 43.618147 |
| Maximum | 53.679197 |
| Range | 26.12407 |
| Interquartile range (IQR) | 7.7667427 |
Descriptive statistics
| Standard deviation | 5.8727589 |
|---|---|
| Coefficient of variation (CV) | 0.16014657 |
| Kurtosis | 0.59451944 |
| Mean | 36.67115 |
| Median Absolute Deviation (MAD) | 1.5095922 |
| Skewness | 0.30477456 |
| Sum | 5513360.7 |
| Variance | 34.489297 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 34.420334 | 146 | 0.1% |
| 34.4208305 | 65 | < 0.1% |
| 39.4835647 | 52 | < 0.1% |
| 27.9552692 | 35 | < 0.1% |
| 39.5401545 | 34 | < 0.1% |
| 39.4953787 | 33 | < 0.1% |
| 39.3831391 | 32 | < 0.1% |
| 36.0775432 | 31 | < 0.1% |
| 32.2680738 | 31 | < 0.1% |
| 39.9531865 | 31 | < 0.1% |
| Other values (135583) | 149856 |
| Value | Count | Frequency (%) |
| 27.555127 | 1 | |
| 27.5582592 | 1 | |
| 27.5616455 | 1 | |
| 27.564137 | 1 | |
| 27.56445724 | 1 | |
| 27.570717 | 1 | |
| 27.578363 | 1 | |
| 27.5786476 | 1 | |
| 27.57870853 | 1 | |
| 27.57947625 | 1 |
| Value | Count | Frequency (%) |
| 53.6791969 | 1 | |
| 53.656598 | 1 | |
| 53.6518378 | 1 | |
| 53.6497432 | 1 | |
| 53.649735 | 1 | |
| 53.6494895 | 1 | |
| 53.64883738 | 1 | |
| 53.64873411 | 1 | |
| 53.648463 | 1 | |
| 53.647812 | 1 |
longitude
Real number (ℝ)
| Distinct | 131918 |
|---|---|
| Distinct (%) | 87.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -89.357339 |
| Minimum | -120.09514 |
|---|---|
| Maximum | -73.200457 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 150346 |
| Negative (%) | 100.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -120.09514 |
|---|---|
| 5-th percentile | -119.7519 |
| Q1 | -90.35781 |
| median | -86.121179 |
| Q3 | -75.421542 |
| 95-th percentile | -75.007048 |
| Maximum | -73.200457 |
| Range | 46.89468 |
| Interquartile range (IQR) | 14.936268 |
Descriptive statistics
| Standard deviation | 14.918502 |
|---|---|
| Coefficient of variation (CV) | -0.16695329 |
| Kurtosis | -0.40968689 |
| Mean | -89.357339 |
| Median Absolute Deviation (MAD) | 10.515837 |
| Skewness | -0.98591957 |
| Sum | -13434519 |
| Variance | 222.56169 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -119.7107494 | 146 | 0.1% |
| -119.7310213 | 69 | < 0.1% |
| -119.6981901 | 65 | < 0.1% |
| -82.4563199 | 46 | < 0.1% |
| -75.1749671 | 43 | < 0.1% |
| -82.2909146 | 41 | < 0.1% |
| -110.8850949 | 40 | < 0.1% |
| -110.9923904 | 39 | < 0.1% |
| -82.6321376 | 38 | < 0.1% |
| -82.7940297 | 37 | < 0.1% |
| Other values (131908) | 149782 |
| Value | Count | Frequency (%) |
| -120.095137 | 1 | |
| -120.0924969 | 1 | |
| -120.0923201 | 1 | |
| -120.092141 | 1 | |
| -120.090842 | 1 | |
| -120.0866753 | 1 | |
| -120.084046 | 1 | |
| -120.083748 | 1 | |
| -120.0837455 | 1 | |
| -120.0822003 | 1 |
| Value | Count | Frequency (%) |
| -73.20045705 | 1 | |
| -74.6585723 | 1 | |
| -74.661348 | 1 | |
| -74.6619316 | 1 | |
| -74.66445891 | 1 | |
| -74.666433 | 1 | |
| -74.6689756 | 1 | |
| -74.677404 | 1 | |
| -74.6802499 | 1 | |
| -74.68259148 | 1 |
stars
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.5967236 |
| Minimum | 1 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 3.5 |
| Q3 | 4.5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1.5 |
Descriptive statistics
| Standard deviation | 0.97442075 |
|---|---|
| Coefficient of variation (CV) | 0.270919 |
| Kurtosis | -0.39744388 |
| Mean | 3.5967236 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | -0.53713136 |
| Sum | 540753 |
| Variance | 0.9494958 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 31125 | |
| 4.5 | 27181 | |
| 3.5 | 26519 | |
| 3 | 18453 | |
| 5 | 16307 | |
| 2.5 | 14316 | |
| 2 | 9527 | 6.3% |
| 1.5 | 4932 | 3.3% |
| 1 | 1986 | 1.3% |
| Value | Count | Frequency (%) |
| 1 | 1986 | 1.3% |
| 1.5 | 4932 | 3.3% |
| 2 | 9527 | 6.3% |
| 2.5 | 14316 | |
| 3 | 18453 | |
| 3.5 | 26519 | |
| 4 | 31125 | |
| 4.5 | 27181 | |
| 5 | 16307 |
| Value | Count | Frequency (%) |
| 5 | 16307 | |
| 4.5 | 27181 | |
| 4 | 31125 | |
| 3.5 | 26519 | |
| 3 | 18453 | |
| 2.5 | 14316 | |
| 2 | 9527 | 6.3% |
| 1.5 | 4932 | 3.3% |
| 1 | 1986 | 1.3% |
review_count
Real number (ℝ)
| Distinct | 1158 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.866561 |
| Minimum | 5 |
|---|---|
| Maximum | 7568 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 8 |
| median | 15 |
| Q3 | 37 |
| 95-th percentile | 173 |
| Maximum | 7568 |
| Range | 7563 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 121.12014 |
|---|---|
| Coefficient of variation (CV) | 2.6995636 |
| Kurtosis | 534.38103 |
| Mean | 44.866561 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 16.220577 |
| Sum | 6745508 |
| Variance | 14670.087 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 14921 | 9.9% |
| 6 | 11673 | 7.8% |
| 7 | 9594 | 6.4% |
| 8 | 8040 | 5.3% |
| 9 | 6875 | 4.6% |
| 10 | 5921 | 3.9% |
| 11 | 5087 | 3.4% |
| 12 | 4676 | 3.1% |
| 13 | 4194 | 2.8% |
| 14 | 3635 | 2.4% |
| Other values (1148) | 75730 |
| Value | Count | Frequency (%) |
| 5 | 14921 | |
| 6 | 11673 | |
| 7 | 9594 | |
| 8 | 8040 | |
| 9 | 6875 | |
| 10 | 5921 | 3.9% |
| 11 | 5087 | 3.4% |
| 12 | 4676 | 3.1% |
| 13 | 4194 | 2.8% |
| 14 | 3635 | 2.4% |
| Value | Count | Frequency (%) |
| 7568 | 1 | |
| 7400 | 1 | |
| 6093 | 1 | |
| 5721 | 1 | |
| 5193 | 1 | |
| 5185 | 1 | |
| 5070 | 1 | |
| 4876 | 1 | |
| 4554 | 1 | |
| 4421 | 1 |
is_open
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 150346 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 119698 | |
| 0 | 30648 | 20.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 119698 | |
| 0 | 30648 | 20.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 119698 | |
| 0 | 30648 | 20.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 150346 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 119698 | |
| 0 | 30648 | 20.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 150346 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 119698 | |
| 0 | 30648 | 20.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 150346 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 119698 | |
| 0 | 30648 | 20.4% |
attributes_ByAppointmentOnly
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 108047 |
| Missing (%) | 71.9% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 26690 | 17.8% |
| True | 15609 | 10.4% |
| (Missing) | 108047 |
categories
Categorical
| Distinct | 83160 |
|---|---|
| Distinct (%) | 55.4% |
| Missing | 103 |
| Missing (%) | 0.1% |
| Memory size | 1.1 MiB |
| Beauty & Spas, Nail Salons | 1012 |
|---|---|
| Restaurants, Pizza | 935 |
| Nail Salons, Beauty & Spas | 934 |
| Pizza, Restaurants | 823 |
| Restaurants, Mexican | 728 |
| Other values (83155) |
Length
| Max length | 503 |
|---|---|
| Median length | 275 |
| Mean length | 59.269384 |
| Min length | 4 |
Characters and Unicode
| Total characters | 8904810 |
|---|---|
| Distinct characters | 60 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 73987 ? |
|---|---|
| Unique (%) | 49.2% |
Sample
| 1st row | Doctors, Traditional Chinese Medicine, Naturopathic/Holistic, Acupuncture, Health & Medical, Nutritionists |
|---|---|
| 2nd row | Shipping Centers, Local Services, Notaries, Mailbox Centers, Printing Services |
| 3rd row | Department Stores, Shopping, Fashion, Home & Garden, Electronics, Furniture Stores |
| 4th row | Restaurants, Food, Bubble Tea, Coffee & Tea, Bakeries |
| 5th row | Brewpubs, Breweries, Food |
Common Values
| Value | Count | Frequency (%) |
| Beauty & Spas, Nail Salons | 1012 | 0.7% |
| Restaurants, Pizza | 935 | 0.6% |
| Nail Salons, Beauty & Spas | 934 | 0.6% |
| Pizza, Restaurants | 823 | 0.5% |
| Restaurants, Mexican | 728 | 0.5% |
| Restaurants, Chinese | 708 | 0.5% |
| Mexican, Restaurants | 672 | 0.4% |
| Chinese, Restaurants | 651 | 0.4% |
| Food, Coffee & Tea | 508 | 0.3% |
| Beauty & Spas, Hair Salons | 493 | 0.3% |
| Other values (83150) | 142779 |
Length
| Value | Count | Frequency (%) |
| 108359 | 9.2% | |
| services | 56156 | 4.8% |
| restaurants | 52343 | 4.4% |
| food | 43813 | 3.7% |
| shopping | 24858 | 2.1% |
| home | 24169 | 2.1% |
| bars | 21022 | 1.8% |
| spas | 17070 | 1.5% |
| beauty | 15836 | 1.3% |
| american | 15046 | 1.3% |
| Other values (1383) | 798541 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1026970 | 11.5% | |
| e | 799798 | 9.0% |
| a | 621171 | 7.0% |
| s | 581681 | 6.5% |
| t | 522287 | 5.9% |
| i | 521471 | 5.9% |
| , | 518349 | 5.8% |
| r | 485237 | 5.4% |
| n | 460516 | 5.2% |
| o | 456449 | 5.1% |
| Other values (50) | 2910881 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6123488 | |
| Uppercase Letter | 1084193 | 12.2% |
| Space Separator | 1026970 | 11.5% |
| Other Punctuation | 638014 | 7.2% |
| Open Punctuation | 14497 | 0.2% |
| Close Punctuation | 14497 | 0.2% |
| Dash Punctuation | 3146 | < 0.1% |
| Decimal Number | 5 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 799798 | |
| a | 621171 | |
| s | 581681 | |
| t | 522287 | |
| i | 521471 | |
| r | 485237 | 7.9% |
| n | 460516 | 7.5% |
| o | 456449 | 7.5% |
| l | 233736 | 3.8% |
| c | 225253 | 3.7% |
| Other values (16) | 1215889 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 202135 | |
| R | 83513 | 7.7% |
| B | 83062 | 7.7% |
| C | 82783 | 7.6% |
| F | 79625 | 7.3% |
| A | 71939 | 6.6% |
| H | 68327 | 6.3% |
| P | 64576 | 6.0% |
| T | 49179 | 4.5% |
| M | 44883 | 4.1% |
| Other values (15) | 254171 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 518349 | |
| & | 108359 | 17.0% |
| / | 6556 | 1.0% |
| ' | 4750 | 0.7% |
Space Separator
| Value | Count | Frequency (%) |
| 1026970 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 14497 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 14497 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3146 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7207681 | |
| Common | 1697129 | 19.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 799798 | 11.1% |
| a | 621171 | 8.6% |
| s | 581681 | 8.1% |
| t | 522287 | 7.2% |
| i | 521471 | 7.2% |
| r | 485237 | 6.7% |
| n | 460516 | 6.4% |
| o | 456449 | 6.3% |
| l | 233736 | 3.2% |
| c | 225253 | 3.1% |
| Other values (41) | 2300082 |
Common
| Value | Count | Frequency (%) |
| 1026970 | ||
| , | 518349 | |
| & | 108359 | 6.4% |
| ( | 14497 | 0.9% |
| ) | 14497 | 0.9% |
| / | 6556 | 0.4% |
| ' | 4750 | 0.3% |
| - | 3146 | 0.2% |
| 3 | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8904810 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1026970 | 11.5% | |
| e | 799798 | 9.0% |
| a | 621171 | 7.0% |
| s | 581681 | 6.5% |
| t | 522287 | 5.9% |
| i | 521471 | 5.9% |
| , | 518349 | 5.8% |
| r | 485237 | 5.4% |
| n | 460516 | 5.2% |
| o | 456449 | 5.1% |
| Other values (50) | 2910881 |
attributes_BusinessAcceptsCreditCards
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 30654 |
| Missing (%) | 20.4% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | 6025 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 113667 | |
| False | 6025 | 4.0% |
| (Missing) | 30654 | 20.4% |
hours_Monday
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 1315 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 35872 |
| Missing (%) | 23.9% |
| Memory size | 1.1 MiB |
| 0:0-0:0 | |
|---|---|
| 8:0-17:0 | 4202 |
| 9:0-17:0 | 3910 |
| 11:0-22:0 | 3241 |
| 11:0-21:0 | 2938 |
| Other values (1310) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 8.1908294 |
| Min length | 7 |
Characters and Unicode
| Total characters | 937637 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 458 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 0:0-0:0 |
|---|---|
| 2nd row | 8:0-22:0 |
| 3rd row | 7:0-20:0 |
| 4th row | 0:0-0:0 |
| 5th row | 0:0-0:0 |
Common Values
| Value | Count | Frequency (%) |
| 0:0-0:0 | 31362 | |
| 8:0-17:0 | 4202 | 2.8% |
| 9:0-17:0 | 3910 | 2.6% |
| 11:0-22:0 | 3241 | 2.2% |
| 11:0-21:0 | 2938 | 2.0% |
| 9:0-18:0 | 2599 | 1.7% |
| 10:0-21:0 | 2278 | 1.5% |
| 10:0-18:0 | 2186 | 1.5% |
| 8:0-18:0 | 1884 | 1.3% |
| 10:0-20:0 | 1733 | 1.2% |
| Other values (1305) | 58141 | |
| (Missing) | 35872 |
Length
| Value | Count | Frequency (%) |
| 0:0-0:0 | 31362 | |
| 8:0-17:0 | 4202 | 3.7% |
| 9:0-17:0 | 3910 | 3.4% |
| 11:0-22:0 | 3241 | 2.8% |
| 11:0-21:0 | 2938 | 2.6% |
| 9:0-18:0 | 2599 | 2.3% |
| 10:0-21:0 | 2278 | 2.0% |
| 10:0-18:0 | 2186 | 1.9% |
| 8:0-18:0 | 1884 | 1.6% |
| 10:0-20:0 | 1733 | 1.5% |
| Other values (1305) | 58141 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 317449 | |
| : | 228948 | |
| - | 114474 | 12.2% |
| 1 | 106371 | 11.3% |
| 2 | 50734 | 5.4% |
| 3 | 27397 | 2.9% |
| 9 | 25330 | 2.7% |
| 8 | 25003 | 2.7% |
| 7 | 24768 | 2.6% |
| 6 | 9321 | 1.0% |
| Other values (2) | 7842 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 594215 | |
| Other Punctuation | 228948 | 24.4% |
| Dash Punctuation | 114474 | 12.2% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 317449 | |
| 1 | 106371 | 17.9% |
| 2 | 50734 | 8.5% |
| 3 | 27397 | 4.6% |
| 9 | 25330 | 4.3% |
| 8 | 25003 | 4.2% |
| 7 | 24768 | 4.2% |
| 6 | 9321 | 1.6% |
| 5 | 5391 | 0.9% |
| 4 | 2451 | 0.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 228948 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 114474 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 937637 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 317449 | |
| : | 228948 | |
| - | 114474 | 12.2% |
| 1 | 106371 | 11.3% |
| 2 | 50734 | 5.4% |
| 3 | 27397 | 2.9% |
| 9 | 25330 | 2.7% |
| 8 | 25003 | 2.7% |
| 7 | 24768 | 2.6% |
| 6 | 9321 | 1.0% |
| Other values (2) | 7842 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 937637 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 317449 | |
| : | 228948 | |
| - | 114474 | 12.2% |
| 1 | 106371 | 11.3% |
| 2 | 50734 | 5.4% |
| 3 | 27397 | 2.9% |
| 9 | 25330 | 2.7% |
| 8 | 25003 | 2.7% |
| 7 | 24768 | 2.6% |
| 6 | 9321 | 1.0% |
| Other values (2) | 7842 | 0.8% |
hours_Tuesday
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 1414 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 29715 |
| Missing (%) | 19.8% |
| Memory size | 1.1 MiB |
| 0:0-0:0 | 7078 |
|---|---|
| 8:0-17:0 | 5232 |
| 9:0-17:0 | 4860 |
| 11:0-22:0 | 4255 |
| 11:0-21:0 | 4193 |
| Other values (1409) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 8.5730202 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1034172 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 488 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 8:0-18:30 |
|---|---|
| 2nd row | 8:0-22:0 |
| 3rd row | 7:0-20:0 |
| 4th row | 6:0-22:0 |
| 5th row | 10:0-18:0 |
Common Values
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7078 | 4.7% |
| 8:0-17:0 | 5232 | 3.5% |
| 9:0-17:0 | 4860 | 3.2% |
| 11:0-22:0 | 4255 | 2.8% |
| 11:0-21:0 | 4193 | 2.8% |
| 9:0-18:0 | 3868 | 2.6% |
| 10:0-18:0 | 3578 | 2.4% |
| 10:0-20:0 | 2742 | 1.8% |
| 8:0-18:0 | 2719 | 1.8% |
| 10:0-21:0 | 2695 | 1.8% |
| Other values (1404) | 79411 | |
| (Missing) | 29715 | 19.8% |
Length
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7078 | 5.9% |
| 8:0-17:0 | 5232 | 4.3% |
| 9:0-17:0 | 4860 | 4.0% |
| 11:0-22:0 | 4255 | 3.5% |
| 11:0-21:0 | 4193 | 3.5% |
| 9:0-18:0 | 3868 | 3.2% |
| 10:0-18:0 | 3578 | 3.0% |
| 10:0-20:0 | 2742 | 2.3% |
| 8:0-18:0 | 2719 | 2.3% |
| 10:0-21:0 | 2695 | 2.2% |
| Other values (1404) | 79411 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 291611 | |
| : | 241262 | |
| 1 | 149528 | |
| - | 120631 | |
| 2 | 68196 | 6.6% |
| 3 | 36204 | 3.5% |
| 9 | 35001 | 3.4% |
| 8 | 34838 | 3.4% |
| 7 | 33466 | 3.2% |
| 6 | 12513 | 1.2% |
| Other values (2) | 10922 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 672279 | |
| Other Punctuation | 241262 | 23.3% |
| Dash Punctuation | 120631 | 11.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 291611 | |
| 1 | 149528 | |
| 2 | 68196 | 10.1% |
| 3 | 36204 | 5.4% |
| 9 | 35001 | 5.2% |
| 8 | 34838 | 5.2% |
| 7 | 33466 | 5.0% |
| 6 | 12513 | 1.9% |
| 5 | 7287 | 1.1% |
| 4 | 3635 | 0.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 241262 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 120631 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1034172 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 291611 | |
| : | 241262 | |
| 1 | 149528 | |
| - | 120631 | |
| 2 | 68196 | 6.6% |
| 3 | 36204 | 3.5% |
| 9 | 35001 | 3.4% |
| 8 | 34838 | 3.4% |
| 7 | 33466 | 3.2% |
| 6 | 12513 | 1.2% |
| Other values (2) | 10922 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1034172 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 291611 | |
| : | 241262 | |
| 1 | 149528 | |
| - | 120631 | |
| 2 | 68196 | 6.6% |
| 3 | 36204 | 3.5% |
| 9 | 35001 | 3.4% |
| 8 | 34838 | 3.4% |
| 7 | 33466 | 3.2% |
| 6 | 12513 | 1.2% |
| Other values (2) | 10922 | 1.1% |
hours_Wednesday
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 1403 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 26575 |
| Missing (%) | 17.7% |
| Memory size | 1.1 MiB |
| 0:0-0:0 | 7084 |
|---|---|
| 8:0-17:0 | 5257 |
| 9:0-17:0 | 4824 |
| 11:0-21:0 | 4384 |
| 11:0-22:0 | 4376 |
| Other values (1398) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 8.5815579 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1062148 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 459 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 8:0-18:30 |
|---|---|
| 2nd row | 8:0-22:0 |
| 3rd row | 7:0-20:0 |
| 4th row | 14:0-22:0 |
| 5th row | 6:0-22:0 |
Common Values
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7084 | 4.7% |
| 8:0-17:0 | 5257 | 3.5% |
| 9:0-17:0 | 4824 | 3.2% |
| 11:0-21:0 | 4384 | 2.9% |
| 11:0-22:0 | 4376 | 2.9% |
| 9:0-18:0 | 3685 | 2.5% |
| 10:0-18:0 | 3511 | 2.3% |
| 10:0-21:0 | 2832 | 1.9% |
| 10:0-19:0 | 2818 | 1.9% |
| 8:0-18:0 | 2741 | 1.8% |
| Other values (1393) | 82259 | |
| (Missing) | 26575 | 17.7% |
Length
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7084 | 5.7% |
| 8:0-17:0 | 5257 | 4.2% |
| 9:0-17:0 | 4824 | 3.9% |
| 11:0-21:0 | 4384 | 3.5% |
| 11:0-22:0 | 4376 | 3.5% |
| 9:0-18:0 | 3685 | 3.0% |
| 10:0-18:0 | 3511 | 2.8% |
| 10:0-21:0 | 2832 | 2.3% |
| 10:0-19:0 | 2818 | 2.3% |
| 8:0-18:0 | 2741 | 2.2% |
| Other values (1393) | 82259 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 298735 | |
| : | 247542 | |
| 1 | 154427 | |
| - | 123771 | |
| 2 | 71771 | 6.8% |
| 3 | 37131 | 3.5% |
| 9 | 35773 | 3.4% |
| 8 | 34937 | 3.3% |
| 7 | 34008 | 3.2% |
| 6 | 12928 | 1.2% |
| Other values (2) | 11125 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 690835 | |
| Other Punctuation | 247542 | 23.3% |
| Dash Punctuation | 123771 | 11.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 298735 | |
| 1 | 154427 | |
| 2 | 71771 | 10.4% |
| 3 | 37131 | 5.4% |
| 9 | 35773 | 5.2% |
| 8 | 34937 | 5.1% |
| 7 | 34008 | 4.9% |
| 6 | 12928 | 1.9% |
| 5 | 7433 | 1.1% |
| 4 | 3692 | 0.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 247542 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 123771 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1062148 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 298735 | |
| : | 247542 | |
| 1 | 154427 | |
| - | 123771 | |
| 2 | 71771 | 6.8% |
| 3 | 37131 | 3.5% |
| 9 | 35773 | 3.4% |
| 8 | 34937 | 3.3% |
| 7 | 34008 | 3.2% |
| 6 | 12928 | 1.2% |
| Other values (2) | 11125 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1062148 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 298735 | |
| : | 247542 | |
| 1 | 154427 | |
| - | 123771 | |
| 2 | 71771 | 6.8% |
| 3 | 37131 | 3.5% |
| 9 | 35773 | 3.4% |
| 8 | 34937 | 3.3% |
| 7 | 34008 | 3.2% |
| 6 | 12928 | 1.2% |
| Other values (2) | 11125 | 1.0% |
hours_Thursday
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 1462 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 25148 |
| Missing (%) | 16.7% |
| Memory size | 1.1 MiB |
| 0:0-0:0 | 7112 |
|---|---|
| 8:0-17:0 | 5209 |
| 9:0-17:0 | 4823 |
| 11:0-21:0 | 4331 |
| 11:0-22:0 | 4273 |
| Other values (1457) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 8.5829167 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1074564 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 502 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 8:0-18:30 |
|---|---|
| 2nd row | 8:0-22:0 |
| 3rd row | 7:0-20:0 |
| 4th row | 16:0-22:0 |
| 5th row | 6:0-22:0 |
Common Values
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7112 | 4.7% |
| 8:0-17:0 | 5209 | 3.5% |
| 9:0-17:0 | 4823 | 3.2% |
| 11:0-21:0 | 4331 | 2.9% |
| 11:0-22:0 | 4273 | 2.8% |
| 9:0-18:0 | 3604 | 2.4% |
| 10:0-18:0 | 3447 | 2.3% |
| 10:0-21:0 | 2851 | 1.9% |
| 10:0-19:0 | 2837 | 1.9% |
| 10:0-20:0 | 2747 | 1.8% |
| Other values (1452) | 83964 | |
| (Missing) | 25148 | 16.7% |
Length
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7112 | 5.7% |
| 8:0-17:0 | 5209 | 4.2% |
| 9:0-17:0 | 4823 | 3.9% |
| 11:0-21:0 | 4331 | 3.5% |
| 11:0-22:0 | 4273 | 3.4% |
| 9:0-18:0 | 3604 | 2.9% |
| 10:0-18:0 | 3447 | 2.8% |
| 10:0-21:0 | 2851 | 2.3% |
| 10:0-19:0 | 2837 | 2.3% |
| 10:0-20:0 | 2747 | 2.2% |
| Other values (1452) | 83964 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 302220 | |
| : | 250396 | |
| 1 | 156774 | |
| - | 125198 | |
| 2 | 72182 | 6.7% |
| 3 | 37688 | 3.5% |
| 9 | 36134 | 3.4% |
| 8 | 35105 | 3.3% |
| 7 | 34237 | 3.2% |
| 6 | 13191 | 1.2% |
| Other values (2) | 11439 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 698970 | |
| Other Punctuation | 250396 | 23.3% |
| Dash Punctuation | 125198 | 11.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 302220 | |
| 1 | 156774 | |
| 2 | 72182 | 10.3% |
| 3 | 37688 | 5.4% |
| 9 | 36134 | 5.2% |
| 8 | 35105 | 5.0% |
| 7 | 34237 | 4.9% |
| 6 | 13191 | 1.9% |
| 5 | 7555 | 1.1% |
| 4 | 3884 | 0.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 250396 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 125198 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1074564 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 302220 | |
| : | 250396 | |
| 1 | 156774 | |
| - | 125198 | |
| 2 | 72182 | 6.7% |
| 3 | 37688 | 3.5% |
| 9 | 36134 | 3.4% |
| 8 | 35105 | 3.3% |
| 7 | 34237 | 3.2% |
| 6 | 13191 | 1.2% |
| Other values (2) | 11439 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1074564 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 302220 | |
| : | 250396 | |
| 1 | 156774 | |
| - | 125198 | |
| 2 | 72182 | 6.7% |
| 3 | 37688 | 3.5% |
| 9 | 36134 | 3.4% |
| 8 | 35105 | 3.3% |
| 7 | 34237 | 3.2% |
| 6 | 13191 | 1.2% |
| Other values (2) | 11439 | 1.1% |
hours_Friday
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 1538 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 25347 |
| Missing (%) | 16.9% |
| Memory size | 1.1 MiB |
| 0:0-0:0 | 7100 |
|---|---|
| 9:0-17:0 | 4984 |
| 8:0-17:0 | 4831 |
| 9:0-18:0 | 3943 |
| 10:0-18:0 | 3850 |
| Other values (1533) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 8.5531004 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1069129 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 523 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 8:0-18:30 |
|---|---|
| 2nd row | 8:0-23:0 |
| 3rd row | 7:0-21:0 |
| 4th row | 12:0-22:0 |
| 5th row | 9:0-0:0 |
Common Values
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7100 | 4.7% |
| 9:0-17:0 | 4984 | 3.3% |
| 8:0-17:0 | 4831 | 3.2% |
| 9:0-18:0 | 3943 | 2.6% |
| 10:0-18:0 | 3850 | 2.6% |
| 11:0-22:0 | 3744 | 2.5% |
| 11:0-21:0 | 2824 | 1.9% |
| 11:0-23:0 | 2710 | 1.8% |
| 8:0-18:0 | 2664 | 1.8% |
| 10:0-21:0 | 2610 | 1.7% |
| Other values (1528) | 85739 | |
| (Missing) | 25347 | 16.9% |
Length
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7100 | 5.7% |
| 9:0-17:0 | 4984 | 4.0% |
| 8:0-17:0 | 4831 | 3.9% |
| 9:0-18:0 | 3943 | 3.2% |
| 10:0-18:0 | 3850 | 3.1% |
| 11:0-22:0 | 3744 | 3.0% |
| 11:0-21:0 | 2824 | 2.3% |
| 11:0-23:0 | 2710 | 2.2% |
| 8:0-18:0 | 2664 | 2.1% |
| 10:0-21:0 | 2610 | 2.1% |
| Other values (1528) | 85739 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 300047 | |
| : | 249998 | |
| 1 | 153886 | |
| - | 124999 | |
| 2 | 69334 | 6.5% |
| 3 | 40921 | 3.8% |
| 8 | 35666 | 3.3% |
| 9 | 34959 | 3.3% |
| 7 | 33921 | 3.2% |
| 6 | 13151 | 1.2% |
| Other values (2) | 12247 | 1.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 694132 | |
| Other Punctuation | 249998 | 23.4% |
| Dash Punctuation | 124999 | 11.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 300047 | |
| 1 | 153886 | |
| 2 | 69334 | 10.0% |
| 3 | 40921 | 5.9% |
| 8 | 35666 | 5.1% |
| 9 | 34959 | 5.0% |
| 7 | 33921 | 4.9% |
| 6 | 13151 | 1.9% |
| 5 | 7823 | 1.1% |
| 4 | 4424 | 0.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 249998 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 124999 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1069129 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 300047 | |
| : | 249998 | |
| 1 | 153886 | |
| - | 124999 | |
| 2 | 69334 | 6.5% |
| 3 | 40921 | 3.8% |
| 8 | 35666 | 3.3% |
| 9 | 34959 | 3.3% |
| 7 | 33921 | 3.2% |
| 6 | 13151 | 1.2% |
| Other values (2) | 12247 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1069129 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 300047 | |
| : | 249998 | |
| 1 | 153886 | |
| - | 124999 | |
| 2 | 69334 | 6.5% |
| 3 | 40921 | 3.8% |
| 8 | 35666 | 3.3% |
| 9 | 34959 | 3.3% |
| 7 | 33921 | 3.2% |
| 6 | 13151 | 1.2% |
| Other values (2) | 12247 | 1.1% |
hours_Saturday
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 1439 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 39576 |
| Missing (%) | 26.3% |
| Memory size | 1.1 MiB |
| 0:0-0:0 | 7156 |
|---|---|
| 11:0-22:0 | 3678 |
| 9:0-17:0 | 3525 |
| 10:0-17:0 | 3276 |
| 10:0-18:0 | 3015 |
| Other values (1434) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 8.5292769 |
| Min length | 7 |
Characters and Unicode
| Total characters | 944788 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 499 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | 8:0-14:0 |
|---|---|
| 2nd row | 8:0-23:0 |
| 3rd row | 7:0-21:0 |
| 4th row | 12:0-22:0 |
| 5th row | 9:0-22:0 |
Common Values
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7156 | 4.8% |
| 11:0-22:0 | 3678 | 2.4% |
| 9:0-17:0 | 3525 | 2.3% |
| 10:0-17:0 | 3276 | 2.2% |
| 10:0-18:0 | 3015 | 2.0% |
| 11:0-21:0 | 2679 | 1.8% |
| 11:0-23:0 | 2624 | 1.7% |
| 9:0-18:0 | 2608 | 1.7% |
| 10:0-21:0 | 2502 | 1.7% |
| 8:0-17:0 | 1987 | 1.3% |
| Other values (1429) | 77720 | |
| (Missing) | 39576 |
Length
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7156 | 6.5% |
| 11:0-22:0 | 3678 | 3.3% |
| 9:0-17:0 | 3525 | 3.2% |
| 10:0-17:0 | 3276 | 3.0% |
| 10:0-18:0 | 3015 | 2.7% |
| 11:0-21:0 | 2679 | 2.4% |
| 11:0-23:0 | 2624 | 2.4% |
| 9:0-18:0 | 2608 | 2.4% |
| 10:0-21:0 | 2502 | 2.3% |
| 8:0-17:0 | 1987 | 1.8% |
| Other values (1429) | 77720 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 269834 | |
| : | 221540 | |
| 1 | 140502 | |
| - | 110770 | |
| 2 | 67879 | 7.2% |
| 3 | 32745 | 3.5% |
| 9 | 29252 | 3.1% |
| 8 | 24579 | 2.6% |
| 7 | 22916 | 2.4% |
| 6 | 11755 | 1.2% |
| Other values (2) | 13016 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 612478 | |
| Other Punctuation | 221540 | 23.4% |
| Dash Punctuation | 110770 | 11.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 269834 | |
| 1 | 140502 | |
| 2 | 67879 | 11.1% |
| 3 | 32745 | 5.3% |
| 9 | 29252 | 4.8% |
| 8 | 24579 | 4.0% |
| 7 | 22916 | 3.7% |
| 6 | 11755 | 1.9% |
| 5 | 7653 | 1.2% |
| 4 | 5363 | 0.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 221540 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 110770 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 944788 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 269834 | |
| : | 221540 | |
| 1 | 140502 | |
| - | 110770 | |
| 2 | 67879 | 7.2% |
| 3 | 32745 | 3.5% |
| 9 | 29252 | 3.1% |
| 8 | 24579 | 2.6% |
| 7 | 22916 | 2.4% |
| 6 | 11755 | 1.2% |
| Other values (2) | 13016 | 1.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 944788 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 269834 | |
| : | 221540 | |
| 1 | 140502 | |
| - | 110770 | |
| 2 | 67879 | 7.2% |
| 3 | 32745 | 3.5% |
| 9 | 29252 | 3.1% |
| 8 | 24579 | 2.6% |
| 7 | 22916 | 2.4% |
| 6 | 11755 | 1.2% |
| Other values (2) | 13016 | 1.4% |
attributes_BikeParking
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 77788 |
| Missing (%) | 51.7% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 55040 | |
| False | 17518 | 11.7% |
| (Missing) | 77788 |
attributes_RestaurantsPriceRange2
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 65066 |
| Missing (%) | 43.3% |
| Memory size | 1.1 MiB |
| 2.0 | |
|---|---|
| 1.0 | |
| 3.0 | |
| 4.0 | 1192 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 255840 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 2.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 2.0 | 48581 | |
| 1.0 | 28840 | |
| 3.0 | 6667 | 4.4% |
| 4.0 | 1192 | 0.8% |
| (Missing) | 65066 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2.0 | 48581 | |
| 1.0 | 28840 | |
| 3.0 | 6667 | 7.8% |
| 4.0 | 1192 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 85280 | |
| 0 | 85280 | |
| 2 | 48581 | |
| 1 | 28840 | 11.3% |
| 3 | 6667 | 2.6% |
| 4 | 1192 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 170560 | |
| Other Punctuation | 85280 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 85280 | |
| 2 | 48581 | |
| 1 | 28840 | 16.9% |
| 3 | 6667 | 3.9% |
| 4 | 1192 | 0.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 85280 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 255840 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| . | 85280 | |
| 0 | 85280 | |
| 2 | 48581 | |
| 1 | 28840 | 11.3% |
| 3 | 6667 | 2.6% |
| 4 | 1192 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 255840 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| . | 85280 | |
| 0 | 85280 | |
| 2 | 48581 | |
| 1 | 28840 | 11.3% |
| 3 | 6667 | 2.6% |
| 4 | 1192 | 0.5% |
attributes_CoatCheck
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144766 |
| Missing (%) | 96.3% |
| Memory size | 1.1 MiB |
| False | 5141 |
|---|---|
| True | 439 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 5141 | 3.4% |
| True | 439 | 0.3% |
| (Missing) | 144766 |
attributes_RestaurantsTakeOut
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 92594 |
| Missing (%) | 61.6% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | 4809 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 52943 | |
| False | 4809 | 3.2% |
| (Missing) | 92594 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 98012 |
| Missing (%) | 65.2% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 32146 | 21.4% |
| False | 20188 | 13.4% |
| (Missing) | 98012 |
attributes_Caters
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 110279 |
| Missing (%) | 73.4% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 22337 | 14.9% |
| False | 17730 | 11.8% |
| (Missing) | 110279 |
attributes_WiFi
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 93482 |
| Missing (%) | 62.2% |
| Memory size | 1.1 MiB |
| free | |
|---|---|
| no | |
| paid | 619 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.232168 |
| Min length | 2 |
Characters and Unicode
| Total characters | 183794 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | no |
|---|---|
| 2nd row | free |
| 3rd row | no |
| 4th row | free |
| 5th row | no |
Common Values
| Value | Count | Frequency (%) |
| free | 34414 | 22.9% |
| no | 21831 | 14.5% |
| paid | 619 | 0.4% |
| (Missing) | 93482 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| free | 34414 | |
| no | 21831 | |
| paid | 619 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 68828 | |
| f | 34414 | |
| r | 34414 | |
| n | 21831 | 11.9% |
| o | 21831 | 11.9% |
| p | 619 | 0.3% |
| a | 619 | 0.3% |
| i | 619 | 0.3% |
| d | 619 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 183794 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 68828 | |
| f | 34414 | |
| r | 34414 | |
| n | 21831 | 11.9% |
| o | 21831 | 11.9% |
| p | 619 | 0.3% |
| a | 619 | 0.3% |
| i | 619 | 0.3% |
| d | 619 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 183794 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 68828 | |
| f | 34414 | |
| r | 34414 | |
| n | 21831 | 11.9% |
| o | 21831 | 11.9% |
| p | 619 | 0.3% |
| a | 619 | 0.3% |
| i | 619 | 0.3% |
| d | 619 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 183794 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 68828 | |
| f | 34414 | |
| r | 34414 | |
| n | 21831 | 11.9% |
| o | 21831 | 11.9% |
| p | 619 | 0.3% |
| a | 619 | 0.3% |
| i | 619 | 0.3% |
| d | 619 | 0.3% |
attributes_BusinessParking_garage
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 63461 |
| Missing (%) | 42.2% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 4140 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 82745 | |
| True | 4140 | 2.8% |
| (Missing) | 63461 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 64872 |
| Missing (%) | 43.1% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 62448 | |
| True | 23026 | 15.3% |
| (Missing) | 64872 |
attributes_BusinessParking_validated
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 63692 |
| Missing (%) | 42.4% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 839 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 85815 | |
| True | 839 | 0.6% |
| (Missing) | 63692 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 63830 |
| Missing (%) | 42.5% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 44247 | |
| False | 42269 | |
| (Missing) | 63830 |
attributes_BusinessParking_valet
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 61551 |
| Missing (%) | 40.9% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 1458 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 87337 | |
| True | 1458 | 1.0% |
| (Missing) | 61551 |
attributes_WheelchairAccessible
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 121420 |
| Missing (%) | 80.8% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | 2933 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 25993 | 17.3% |
| False | 2933 | 2.0% |
| (Missing) | 121420 |
attributes_HappyHour
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 135177 |
| Missing (%) | 89.9% |
| Memory size | 1.1 MiB |
| True | 9721 |
|---|---|
| False | 5448 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 9721 | 6.5% |
| False | 5448 | 3.6% |
| (Missing) | 135177 |
attributes_OutdoorSeating
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 103426 |
| Missing (%) | 68.8% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 24371 | 16.2% |
| True | 22549 | 15.0% |
| (Missing) | 103426 |
attributes_HasTV
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 105281 |
| Missing (%) | 70.0% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 34154 | 22.7% |
| False | 10911 | 7.3% |
| (Missing) | 105281 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 105387 |
| Missing (%) | 70.1% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 30105 | 20.0% |
| True | 14854 | 9.9% |
| (Missing) | 105387 |
attributes_DogsAllowed
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 132088 |
| Missing (%) | 87.9% |
| Memory size | 1.1 MiB |
| False | 12267 |
|---|---|
| True | 5991 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 12267 | 8.2% |
| True | 5991 | 4.0% |
| (Missing) | 132088 |
hours_Sunday
Categorical
HIGH CARDINALITY  MISSING 
| Distinct | 1291 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 69174 |
| Missing (%) | 46.0% |
| Memory size | 1.1 MiB |
| 0:0-0:0 | |
|---|---|
| 11:0-21:0 | 3333 |
| 11:0-22:0 | 2748 |
| 11:0-18:0 | 2376 |
| 11:0-17:0 | 2046 |
| Other values (1286) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.5954393 |
| Min length | 7 |
Characters and Unicode
| Total characters | 697709 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 452 ? |
|---|---|
| Unique (%) | 0.6% |
Sample
| 1st row | 8:0-22:0 |
|---|---|
| 2nd row | 7:0-21:0 |
| 3rd row | 12:0-18:0 |
| 4th row | 8:0-22:0 |
| 5th row | 12:0-18:0 |
Common Values
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7016 | 4.7% |
| 11:0-21:0 | 3333 | 2.2% |
| 11:0-22:0 | 2748 | 1.8% |
| 11:0-18:0 | 2376 | 1.6% |
| 11:0-17:0 | 2046 | 1.4% |
| 12:0-17:0 | 2026 | 1.3% |
| 10:0-18:0 | 1820 | 1.2% |
| 12:0-18:0 | 1777 | 1.2% |
| 9:0-17:0 | 1634 | 1.1% |
| 10:0-17:0 | 1610 | 1.1% |
| Other values (1281) | 54786 | |
| (Missing) | 69174 |
Length
| Value | Count | Frequency (%) |
| 0:0-0:0 | 7016 | 8.6% |
| 11:0-21:0 | 3333 | 4.1% |
| 11:0-22:0 | 2748 | 3.4% |
| 11:0-18:0 | 2376 | 2.9% |
| 11:0-17:0 | 2046 | 2.5% |
| 12:0-17:0 | 2026 | 2.5% |
| 10:0-18:0 | 1820 | 2.2% |
| 12:0-18:0 | 1777 | 2.2% |
| 9:0-17:0 | 1634 | 2.0% |
| 10:0-17:0 | 1610 | 2.0% |
| Other values (1281) | 54786 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 199911 | |
| : | 162344 | |
| 1 | 116462 | |
| - | 81172 | |
| 2 | 56514 | 8.1% |
| 3 | 18220 | 2.6% |
| 7 | 16624 | 2.4% |
| 8 | 15371 | 2.2% |
| 9 | 13011 | 1.9% |
| 6 | 8886 | 1.3% |
| Other values (2) | 9194 | 1.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 454193 | |
| Other Punctuation | 162344 | 23.3% |
| Dash Punctuation | 81172 | 11.6% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 199911 | |
| 1 | 116462 | |
| 2 | 56514 | 12.4% |
| 3 | 18220 | 4.0% |
| 7 | 16624 | 3.7% |
| 8 | 15371 | 3.4% |
| 9 | 13011 | 2.9% |
| 6 | 8886 | 2.0% |
| 5 | 5537 | 1.2% |
| 4 | 3657 | 0.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 162344 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 81172 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 697709 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 199911 | |
| : | 162344 | |
| 1 | 116462 | |
| - | 81172 | |
| 2 | 56514 | 8.1% |
| 3 | 18220 | 2.6% |
| 7 | 16624 | 2.4% |
| 8 | 15371 | 2.2% |
| 9 | 13011 | 1.9% |
| 6 | 8886 | 1.3% |
| Other values (2) | 9194 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 697709 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 199911 | |
| : | 162344 | |
| 1 | 116462 | |
| - | 81172 | |
| 2 | 56514 | 8.1% |
| 3 | 18220 | 2.6% |
| 7 | 16624 | 2.4% |
| 8 | 15371 | 2.2% |
| 9 | 13011 | 1.9% |
| 6 | 8886 | 1.3% |
| Other values (2) | 9194 | 1.3% |
attributes_Alcohol
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 107195 |
| Missing (%) | 71.3% |
| Memory size | 1.1 MiB |
| none | |
|---|---|
| full_bar | |
| beer_and_wine |
Length
| Max length | 13 |
|---|---|
| Median length | 8 |
| Mean length | 6.7857755 |
| Min length | 4 |
Characters and Unicode
| Total characters | 292813 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | none |
|---|---|
| 2nd row | none |
| 3rd row | full_bar |
| 4th row | none |
| 5th row | none |
Common Values
| Value | Count | Frequency (%) |
| none | 20910 | 13.9% |
| full_bar | 15992 | 10.6% |
| beer_and_wine | 6249 | 4.2% |
| (Missing) | 107195 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| none | 20910 | |
| full_bar | 15992 | |
| beer_and_wine | 6249 | 14.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 54318 | |
| e | 39657 | |
| l | 31984 | |
| _ | 28490 | |
| b | 22241 | |
| a | 22241 | |
| r | 22241 | |
| o | 20910 | 7.1% |
| f | 15992 | 5.5% |
| u | 15992 | 5.5% |
| Other values (3) | 18747 | 6.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 264323 | |
| Connector Punctuation | 28490 | 9.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 54318 | |
| e | 39657 | |
| l | 31984 | |
| b | 22241 | |
| a | 22241 | |
| r | 22241 | |
| o | 20910 | 7.9% |
| f | 15992 | 6.1% |
| u | 15992 | 6.1% |
| d | 6249 | 2.4% |
| Other values (2) | 12498 | 4.7% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 28490 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 264323 | |
| Common | 28490 | 9.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 54318 | |
| e | 39657 | |
| l | 31984 | |
| b | 22241 | |
| a | 22241 | |
| r | 22241 | |
| o | 20910 | 7.9% |
| f | 15992 | 6.1% |
| u | 15992 | 6.1% |
| d | 6249 | 2.4% |
| Other values (2) | 12498 | 4.7% |
Common
| Value | Count | Frequency (%) |
| _ | 28490 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 292813 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 54318 | |
| e | 39657 | |
| l | 31984 | |
| _ | 28490 | |
| b | 22241 | |
| a | 22241 | |
| r | 22241 | |
| o | 20910 | 7.1% |
| f | 15992 | 5.5% |
| u | 15992 | 5.5% |
| Other values (3) | 18747 | 6.4% |
attributes_GoodForKids
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 96999 |
| Missing (%) | 64.5% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | 9442 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 43905 | |
| False | 9442 | 6.3% |
| (Missing) | 96999 |
attributes_RestaurantsAttire
Categorical
IMBALANCE  MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 111129 |
| Missing (%) | 73.9% |
| Memory size | 1.1 MiB |
| casual | |
|---|---|
| dressy | 803 |
| formal | 70 |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 235302 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | casual |
|---|---|
| 2nd row | casual |
| 3rd row | casual |
| 4th row | casual |
| 5th row | casual |
Common Values
| Value | Count | Frequency (%) |
| casual | 38344 | 25.5% |
| dressy | 803 | 0.5% |
| formal | 70 | < 0.1% |
| (Missing) | 111129 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| casual | 38344 | |
| dressy | 803 | 2.0% |
| formal | 70 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 76758 | |
| s | 39950 | |
| l | 38414 | |
| c | 38344 | |
| u | 38344 | |
| r | 873 | 0.4% |
| d | 803 | 0.3% |
| e | 803 | 0.3% |
| y | 803 | 0.3% |
| f | 70 | < 0.1% |
| Other values (2) | 140 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 235302 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 76758 | |
| s | 39950 | |
| l | 38414 | |
| c | 38344 | |
| u | 38344 | |
| r | 873 | 0.4% |
| d | 803 | 0.3% |
| e | 803 | 0.3% |
| y | 803 | 0.3% |
| f | 70 | < 0.1% |
| Other values (2) | 140 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 235302 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 76758 | |
| s | 39950 | |
| l | 38414 | |
| c | 38344 | |
| u | 38344 | |
| r | 873 | 0.4% |
| d | 803 | 0.3% |
| e | 803 | 0.3% |
| y | 803 | 0.3% |
| f | 70 | < 0.1% |
| Other values (2) | 140 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 235302 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 76758 | |
| s | 39950 | |
| l | 38414 | |
| c | 38344 | |
| u | 38344 | |
| r | 873 | 0.4% |
| d | 803 | 0.3% |
| e | 803 | 0.3% |
| y | 803 | 0.3% |
| f | 70 | < 0.1% |
| Other values (2) | 140 | 0.1% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 130379 |
| Missing (%) | 86.7% |
| Memory size | 1.1 MiB |
| True | 12674 |
|---|---|
| False | 7293 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 12674 | 8.4% |
| False | 7293 | 4.9% |
| (Missing) | 130379 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 106197 |
| Missing (%) | 70.6% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | 6001 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 38148 | 25.4% |
| False | 6001 | 4.0% |
| (Missing) | 106197 |
attributes_DriveThru
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 143341 |
| Missing (%) | 95.3% |
| Memory size | 1.1 MiB |
| True | 4374 |
|---|---|
| False | 2631 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 4374 | 2.9% |
| False | 2631 | 1.7% |
| (Missing) | 143341 |
attributes_NoiseLevel
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 112392 |
| Missing (%) | 74.8% |
| Memory size | 1.1 MiB |
| average | |
|---|---|
| quiet | |
| loud | |
| very_loud | 1200 |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.4292038 |
| Min length | 4 |
Characters and Unicode
| Total characters | 244014 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | average |
|---|---|
| 2nd row | average |
| 3rd row | average |
| 4th row | quiet |
| 5th row | average |
Common Values
| Value | Count | Frequency (%) |
| average | 26188 | 17.4% |
| quiet | 7634 | 5.1% |
| loud | 2932 | 2.0% |
| very_loud | 1200 | 0.8% |
| (Missing) | 112392 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| average | 26188 | |
| quiet | 7634 | 20.1% |
| loud | 2932 | 7.7% |
| very_loud | 1200 | 3.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 61210 | |
| a | 52376 | |
| v | 27388 | |
| r | 27388 | |
| g | 26188 | |
| u | 11766 | 4.8% |
| q | 7634 | 3.1% |
| i | 7634 | 3.1% |
| t | 7634 | 3.1% |
| l | 4132 | 1.7% |
| Other values (4) | 10664 | 4.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 242814 | |
| Connector Punctuation | 1200 | 0.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 61210 | |
| a | 52376 | |
| v | 27388 | |
| r | 27388 | |
| g | 26188 | |
| u | 11766 | 4.8% |
| q | 7634 | 3.1% |
| i | 7634 | 3.1% |
| t | 7634 | 3.1% |
| l | 4132 | 1.7% |
| Other values (3) | 9464 | 3.9% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1200 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 242814 | |
| Common | 1200 | 0.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 61210 | |
| a | 52376 | |
| v | 27388 | |
| r | 27388 | |
| g | 26188 | |
| u | 11766 | 4.8% |
| q | 7634 | 3.1% |
| i | 7634 | 3.1% |
| t | 7634 | 3.1% |
| l | 4132 | 1.7% |
| Other values (3) | 9464 | 3.9% |
Common
| Value | Count | Frequency (%) |
| _ | 1200 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 244014 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 61210 | |
| a | 52376 | |
| v | 27388 | |
| r | 27388 | |
| g | 26188 | |
| u | 11766 | 4.8% |
| q | 7634 | 3.1% |
| i | 7634 | 3.1% |
| t | 7634 | 3.1% |
| l | 4132 | 1.7% |
| Other values (4) | 10664 | 4.4% |
attributes_Ambience_romantic
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 109954 |
| Missing (%) | 73.1% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 694 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 39698 | 26.4% |
| True | 694 | 0.5% |
| (Missing) | 109954 |
attributes_Ambience_intimate
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 110860 |
| Missing (%) | 73.7% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 861 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 38625 | 25.7% |
| True | 861 | 0.6% |
| (Missing) | 110860 |
attributes_Ambience_touristy
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 110265 |
| Missing (%) | 73.3% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 317 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 39764 | 26.4% |
| True | 317 | 0.2% |
| (Missing) | 110265 |
attributes_Ambience_hipster
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 111021 |
| Missing (%) | 73.8% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 1118 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 38207 | 25.4% |
| True | 1118 | 0.7% |
| (Missing) | 111021 |
attributes_Ambience_divey
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 112075 |
| Missing (%) | 74.5% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 1468 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 36803 | 24.5% |
| True | 1468 | 1.0% |
| (Missing) | 112075 |
attributes_Ambience_classy
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 110211 |
| Missing (%) | 73.3% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 6233 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 33902 | 22.5% |
| True | 6233 | 4.1% |
| (Missing) | 110211 |
attributes_Ambience_trendy
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 111945 |
| Missing (%) | 74.5% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 2508 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 35893 | 23.9% |
| True | 2508 | 1.7% |
| (Missing) | 111945 |
attributes_Ambience_upscale
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 109534 |
| Missing (%) | 72.9% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 451 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 40361 | 26.8% |
| True | 451 | 0.3% |
| (Missing) | 109534 |
attributes_Ambience_casual
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 108832 |
| Missing (%) | 72.4% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 20869 | 13.9% |
| False | 20645 | 13.7% |
| (Missing) | 108832 |
attributes_GoodForMeal_dessert
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 126155 |
| Missing (%) | 83.9% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 1778 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 22413 | 14.9% |
| True | 1778 | 1.2% |
| (Missing) | 126155 |
attributes_GoodForMeal_latenight
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 125306 |
| Missing (%) | 83.3% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 1331 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 23709 | 15.8% |
| True | 1331 | 0.9% |
| (Missing) | 125306 |
attributes_GoodForMeal_lunch
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 123957 |
| Missing (%) | 82.4% |
| Memory size | 1.1 MiB |
| True | |
|---|---|
| False | 12173 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 14216 | 9.5% |
| False | 12173 | 8.1% |
| (Missing) | 123957 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 122914 |
| Missing (%) | 81.8% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 14334 | 9.5% |
| True | 13098 | 8.7% |
| (Missing) | 122914 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 125160 |
| Missing (%) | 83.2% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 2876 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 22310 | 14.8% |
| True | 2876 | 1.9% |
| (Missing) | 125160 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 124021 |
| Missing (%) | 82.5% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 3032 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 23293 | 15.5% |
| True | 3032 | 2.0% |
| (Missing) | 124021 |
attributes_BusinessAcceptsBitcoin
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 132919 |
| Missing (%) | 88.4% |
| Memory size | 1.1 MiB |
| False | |
|---|---|
| True | 470 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 16957 | 11.3% |
| True | 470 | 0.3% |
| (Missing) | 132919 |
attributes_Smoking
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 145793 |
| Missing (%) | 97.0% |
| Memory size | 1.1 MiB |
| no | |
|---|---|
| outdoor | |
| yes |
Length
| Max length | 7 |
|---|---|
| Median length | 2 |
| Mean length | 4.068087 |
| Min length | 2 |
Characters and Unicode
| Total characters | 18522 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | no |
|---|---|
| 2nd row | no |
| 3rd row | no |
| 4th row | no |
| 5th row | no |
Common Values
| Value | Count | Frequency (%) |
| no | 2405 | 1.6% |
| outdoor | 1817 | 1.2% |
| yes | 331 | 0.2% |
| (Missing) | 145793 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 2405 | |
| outdoor | 1817 | |
| yes | 331 | 7.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 7856 | |
| n | 2405 | 13.0% |
| u | 1817 | 9.8% |
| t | 1817 | 9.8% |
| d | 1817 | 9.8% |
| r | 1817 | 9.8% |
| y | 331 | 1.8% |
| e | 331 | 1.8% |
| s | 331 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 18522 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 7856 | |
| n | 2405 | 13.0% |
| u | 1817 | 9.8% |
| t | 1817 | 9.8% |
| d | 1817 | 9.8% |
| r | 1817 | 9.8% |
| y | 331 | 1.8% |
| e | 331 | 1.8% |
| s | 331 | 1.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 18522 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 7856 | |
| n | 2405 | 13.0% |
| u | 1817 | 9.8% |
| t | 1817 | 9.8% |
| d | 1817 | 9.8% |
| r | 1817 | 9.8% |
| y | 331 | 1.8% |
| e | 331 | 1.8% |
| s | 331 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 18522 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 7856 | |
| n | 2405 | 13.0% |
| u | 1817 | 9.8% |
| t | 1817 | 9.8% |
| d | 1817 | 9.8% |
| r | 1817 | 9.8% |
| y | 331 | 1.8% |
| e | 331 | 1.8% |
| s | 331 | 1.8% |
attributes_Music_dj
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 143632 |
| Missing (%) | 95.5% |
| Memory size | 1.1 MiB |
| False | 6358 |
|---|---|
| True | 356 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 6358 | 4.2% |
| True | 356 | 0.2% |
| (Missing) | 143632 |
attributes_Music_background_music
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 143278 |
| Missing (%) | 95.3% |
| Memory size | 1.1 MiB |
| False | 6866 |
|---|---|
| True | 202 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 6866 | 4.6% |
| True | 202 | 0.1% |
| (Missing) | 143278 |
attributes_Music_no_music
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 143488 |
| Missing (%) | 95.4% |
| Memory size | 1.1 MiB |
| False | 6858 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| False | 6858 | 4.6% |
| (Missing) | 143488 |
attributes_Music_jukebox
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144158 |
| Missing (%) | 95.9% |
| Memory size | 1.1 MiB |
| False | 5699 |
|---|---|
| True | 489 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 5699 | 3.8% |
| True | 489 | 0.3% |
| (Missing) | 144158 |
attributes_Music_live
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 143613 |
| Missing (%) | 95.5% |
| Memory size | 1.1 MiB |
| False | 4697 |
|---|---|
| True | 2036 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 4697 | 3.1% |
| True | 2036 | 1.4% |
| (Missing) | 143613 |
attributes_Music_video
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 143276 |
| Missing (%) | 95.3% |
| Memory size | 1.1 MiB |
| False | 7054 |
|---|---|
| True | 16 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 7054 | 4.7% |
| True | 16 | < 0.1% |
| (Missing) | 143276 |
attributes_Music_karaoke
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144556 |
| Missing (%) | 96.1% |
| Memory size | 1.1 MiB |
| False | 5715 |
|---|---|
| True | 75 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 5715 | 3.8% |
| True | 75 | < 0.1% |
| (Missing) | 144556 |
attributes_GoodForDancing
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 145718 |
| Missing (%) | 96.9% |
| Memory size | 1.1 MiB |
| False | 3726 |
|---|---|
| True | 902 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3726 | 2.5% |
| True | 902 | 0.6% |
| (Missing) | 145718 |
attributes_AcceptsInsurance
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144641 |
| Missing (%) | 96.2% |
| Memory size | 1.1 MiB |
| True | 3938 |
|---|---|
| False | 1767 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 3938 | 2.6% |
| False | 1767 | 1.2% |
| (Missing) | 144641 |
attributes_BestNights_monday
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144663 |
| Missing (%) | 96.2% |
| Memory size | 1.1 MiB |
| False | 5056 |
|---|---|
| True | 627 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 5056 | 3.4% |
| True | 627 | 0.4% |
| (Missing) | 144663 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144663 |
| Missing (%) | 96.2% |
| Memory size | 1.1 MiB |
| False | 4907 |
|---|---|
| True | 776 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 4907 | 3.3% |
| True | 776 | 0.5% |
| (Missing) | 144663 |
attributes_BestNights_friday
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144663 |
| Missing (%) | 96.2% |
| Memory size | 1.1 MiB |
| True | 3090 |
|---|---|
| False | 2593 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 3090 | 2.1% |
| False | 2593 | 1.7% |
| (Missing) | 144663 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144663 |
| Missing (%) | 96.2% |
| Memory size | 1.1 MiB |
| False | 4801 |
|---|---|
| True | 882 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 4801 | 3.2% |
| True | 882 | 0.6% |
| (Missing) | 144663 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144663 |
| Missing (%) | 96.2% |
| Memory size | 1.1 MiB |
| False | 4149 |
|---|---|
| True | 1534 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 4149 | 2.8% |
| True | 1534 | 1.0% |
| (Missing) | 144663 |
attributes_BestNights_sunday
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144663 |
| Missing (%) | 96.2% |
| Memory size | 1.1 MiB |
| False | 4913 |
|---|---|
| True | 770 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 4913 | 3.3% |
| True | 770 | 0.5% |
| (Missing) | 144663 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 144663 |
| Missing (%) | 96.2% |
| Memory size | 1.1 MiB |
| True | 3092 |
|---|---|
| False | 2591 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 3092 | 2.1% |
| False | 2591 | 1.7% |
| (Missing) | 144663 |
attributes_BYOB
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 145907 |
| Missing (%) | 97.0% |
| Memory size | 1.1 MiB |
| False | 3437 |
|---|---|
| True | 1002 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 3437 | 2.3% |
| True | 1002 | 0.7% |
| (Missing) | 145907 |
attributes_Corkage
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 146804 |
| Missing (%) | 97.6% |
| Memory size | 1.1 MiB |
| False | 2446 |
|---|---|
| True | 1096 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 2446 | 1.6% |
| True | 1096 | 0.7% |
| (Missing) | 146804 |
attributes_BYOBCorkage
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 148907 |
| Missing (%) | 99.0% |
| Memory size | 1.1 MiB |
| no | |
|---|---|
| yes_free | |
| yes_corkage |
Length
| Max length | 11 |
|---|---|
| Median length | 2 |
| Mean length | 5.0979847 |
| Min length | 2 |
Characters and Unicode
| Total characters | 7336 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | yes_free |
|---|---|
| 2nd row | no |
| 3rd row | yes_free |
| 4th row | no |
| 5th row | yes_free |
Common Values
| Value | Count | Frequency (%) |
| no | 747 | 0.5% |
| yes_free | 590 | 0.4% |
| yes_corkage | 102 | 0.1% |
| (Missing) | 148907 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 747 | |
| yes_free | 590 | |
| yes_corkage | 102 | 7.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1974 | |
| o | 849 | |
| n | 747 | 10.2% |
| y | 692 | 9.4% |
| s | 692 | 9.4% |
| _ | 692 | 9.4% |
| r | 692 | 9.4% |
| f | 590 | 8.0% |
| c | 102 | 1.4% |
| k | 102 | 1.4% |
| Other values (2) | 204 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 6644 | |
| Connector Punctuation | 692 | 9.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 1974 | |
| o | 849 | |
| n | 747 | 11.2% |
| y | 692 | 10.4% |
| s | 692 | 10.4% |
| r | 692 | 10.4% |
| f | 590 | 8.9% |
| c | 102 | 1.5% |
| k | 102 | 1.5% |
| a | 102 | 1.5% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 692 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6644 | |
| Common | 692 | 9.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 1974 | |
| o | 849 | |
| n | 747 | 11.2% |
| y | 692 | 10.4% |
| s | 692 | 10.4% |
| r | 692 | 10.4% |
| f | 590 | 8.9% |
| c | 102 | 1.5% |
| k | 102 | 1.5% |
| a | 102 | 1.5% |
Common
| Value | Count | Frequency (%) |
| _ | 692 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7336 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 1974 | |
| o | 849 | |
| n | 747 | 10.2% |
| y | 692 | 9.4% |
| s | 692 | 9.4% |
| _ | 692 | 9.4% |
| r | 692 | 9.4% |
| f | 590 | 8.0% |
| c | 102 | 1.4% |
| k | 102 | 1.4% |
| Other values (2) | 204 | 2.8% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 149344 |
| Missing (%) | 99.3% |
| Memory size | 1.1 MiB |
| False | 675 |
|---|---|
| True | 327 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 675 | 0.4% |
| True | 327 | 0.2% |
| (Missing) | 149344 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 149311 |
| Missing (%) | 99.3% |
| Memory size | 1.1 MiB |
| True | 822 |
|---|---|
| False | 213 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 822 | 0.5% |
| False | 213 | 0.1% |
| (Missing) | 149311 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 149311 |
| Missing (%) | 99.3% |
| Memory size | 1.1 MiB |
| True | 600 |
|---|---|
| False | 435 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 600 | 0.4% |
| False | 435 | 0.3% |
| (Missing) | 149311 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 149344 |
| Missing (%) | 99.3% |
| Memory size | 1.1 MiB |
| False | 698 |
|---|---|
| True | 304 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 698 | 0.5% |
| True | 304 | 0.2% |
| (Missing) | 149344 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 149311 |
| Missing (%) | 99.3% |
| Memory size | 1.1 MiB |
| True | 734 |
|---|---|
| False | 301 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 734 | 0.5% |
| False | 301 | 0.2% |
| (Missing) | 149311 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 149311 |
| Missing (%) | 99.3% |
| Memory size | 1.1 MiB |
| False | 521 |
|---|---|
| True | 514 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 521 | 0.3% |
| True | 514 | 0.3% |
| (Missing) | 149311 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 149311 |
| Missing (%) | 99.3% |
| Memory size | 1.1 MiB |
| False | 572 |
|---|---|
| True | 463 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 572 | 0.4% |
| True | 463 | 0.3% |
| (Missing) | 149311 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 149344 |
| Missing (%) | 99.3% |
| Memory size | 1.1 MiB |
| False | 596 |
|---|---|
| True | 406 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 596 | 0.4% |
| True | 406 | 0.3% |
| (Missing) | 149344 |
attributes_Open24Hours
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 150307 |
| Missing (%) | > 99.9% |
| Memory size | 1.1 MiB |
| False | 20 |
|---|---|
| True | 19 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 20 | < 0.1% |
| True | 19 | < 0.1% |
| (Missing) | 150307 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 150327 |
| Missing (%) | > 99.9% |
| Memory size | 1.1 MiB |
| True | 16 |
|---|---|
| False | 3 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 16 | < 0.1% |
| False | 3 | < 0.1% |
| (Missing) | 150327 |
attributes_AgesAllowed
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 150217 |
| Missing (%) | 99.9% |
| Memory size | 1.1 MiB |
| allages | |
|---|---|
| 21plus | |
| 18plus | 6 |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.5968992 |
| Min length | 6 |
Characters and Unicode
| Total characters | 851 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 21plus |
|---|---|
| 2nd row | allages |
| 3rd row | allages |
| 4th row | allages |
| 5th row | allages |
Common Values
| Value | Count | Frequency (%) |
| allages | 77 | 0.1% |
| 21plus | 46 | < 0.1% |
| 18plus | 6 | < 0.1% |
| (Missing) | 150217 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| allages | 77 | |
| 21plus | 46 | |
| 18plus | 6 | 4.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 206 | |
| a | 154 | |
| s | 129 | |
| g | 77 | 9.0% |
| e | 77 | 9.0% |
| 1 | 52 | 6.1% |
| p | 52 | 6.1% |
| u | 52 | 6.1% |
| 2 | 46 | 5.4% |
| 8 | 6 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 747 | |
| Decimal Number | 104 | 12.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 206 | |
| a | 154 | |
| s | 129 | |
| g | 77 | 10.3% |
| e | 77 | 10.3% |
| p | 52 | 7.0% |
| u | 52 | 7.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 52 | |
| 2 | 46 | |
| 8 | 6 | 5.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 747 | |
| Common | 104 | 12.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| l | 206 | |
| a | 154 | |
| s | 129 | |
| g | 77 | 10.3% |
| e | 77 | 10.3% |
| p | 52 | 7.0% |
| u | 52 | 7.0% |
Common
| Value | Count | Frequency (%) |
| 1 | 52 | |
| 2 | 46 | |
| 8 | 6 | 5.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 851 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| l | 206 | |
| a | 154 | |
| s | 129 | |
| g | 77 | 9.0% |
| e | 77 | 9.0% |
| 1 | 52 | 6.1% |
| p | 52 | 6.1% |
| u | 52 | 6.1% |
| 2 | 46 | 5.4% |
| 8 | 6 | 0.7% |
| Distinct | 2 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 150316 |
| Missing (%) | > 99.9% |
| Memory size | 1.1 MiB |
| False | 24 |
|---|---|
| True | 6 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 24 | < 0.1% |
| True | 6 | < 0.1% |
| (Missing) | 150316 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 150316 |
| Missing (%) | > 99.9% |
| Memory size | 1.1 MiB |
| True | 19 |
|---|---|
| False | 11 |
| (Missing) |
| Value | Count | Frequency (%) |
| True | 19 | < 0.1% |
| False | 11 | < 0.1% |
| (Missing) | 150316 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 150316 |
| Missing (%) | > 99.9% |
| Memory size | 1.1 MiB |
| False | 16 |
|---|---|
| True | 14 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 16 | < 0.1% |
| True | 14 | < 0.1% |
| (Missing) | 150316 |
attributes_DietaryRestrictions_kosher
Boolean
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 150316 |
| Missing (%) | > 99.9% |
| Memory size | 1.1 MiB |
| False | 30 |
|---|---|
| (Missing) |
| Value | Count | Frequency (%) |
| False | 30 | < 0.1% |
| (Missing) | 150316 |
attributes_DietaryRestrictions_halal
Boolean
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 150316 |
| Missing (%) | > 99.9% |
| Memory size | 1.1 MiB |
| False | 29 |
|---|---|
| True | 1 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 29 | < 0.1% |
| True | 1 | < 0.1% |
| (Missing) | 150316 |
| Distinct | 2 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 150316 |
| Missing (%) | > 99.9% |
| Memory size | 1.1 MiB |
| False | 26 |
|---|---|
| True | 4 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 26 | < 0.1% |
| True | 4 | < 0.1% |
| (Missing) | 150316 |
| business_id | name | address | city | state | postal_code | latitude | longitude | stars | review_count | is_open | attributes_ByAppointmentOnly | categories | attributes_BusinessAcceptsCreditCards | hours_Monday | hours_Tuesday | hours_Wednesday | hours_Thursday | hours_Friday | hours_Saturday | attributes_BikeParking | attributes_RestaurantsPriceRange2 | attributes_CoatCheck | attributes_RestaurantsTakeOut | attributes_RestaurantsDelivery | attributes_Caters | attributes_WiFi | attributes_BusinessParking_garage | attributes_BusinessParking_street | attributes_BusinessParking_validated | attributes_BusinessParking_lot | attributes_BusinessParking_valet | attributes_WheelchairAccessible | attributes_HappyHour | attributes_OutdoorSeating | attributes_HasTV | attributes_RestaurantsReservations | attributes_DogsAllowed | hours_Sunday | attributes_Alcohol | attributes_GoodForKids | attributes_RestaurantsAttire | attributes_RestaurantsTableService | attributes_RestaurantsGoodForGroups | attributes_DriveThru | attributes_NoiseLevel | attributes_Ambience_romantic | attributes_Ambience_intimate | attributes_Ambience_touristy | attributes_Ambience_hipster | attributes_Ambience_divey | attributes_Ambience_classy | attributes_Ambience_trendy | attributes_Ambience_upscale | attributes_Ambience_casual | attributes_GoodForMeal_dessert | attributes_GoodForMeal_latenight | attributes_GoodForMeal_lunch | attributes_GoodForMeal_dinner | attributes_GoodForMeal_brunch | attributes_GoodForMeal_breakfast | attributes_BusinessAcceptsBitcoin | attributes_Smoking | attributes_Music_dj | attributes_Music_background_music | attributes_Music_no_music | attributes_Music_jukebox | attributes_Music_live | attributes_Music_video | attributes_Music_karaoke | attributes_GoodForDancing | attributes_AcceptsInsurance | attributes_BestNights_monday | attributes_BestNights_tuesday | attributes_BestNights_friday | attributes_BestNights_wednesday | attributes_BestNights_thursday | attributes_BestNights_sunday | attributes_BestNights_saturday | attributes_BYOB | attributes_Corkage | attributes_BYOBCorkage | attributes_HairSpecializesIn_straightperms | attributes_HairSpecializesIn_coloring | attributes_HairSpecializesIn_extensions | attributes_HairSpecializesIn_africanamerican | attributes_HairSpecializesIn_curly | attributes_HairSpecializesIn_kids | attributes_HairSpecializesIn_perms | attributes_HairSpecializesIn_asian | attributes_Open24Hours | attributes_RestaurantsCounterService | attributes_AgesAllowed | attributes_DietaryRestrictions_dairy-free | attributes_DietaryRestrictions_gluten-free | attributes_DietaryRestrictions_vegan | attributes_DietaryRestrictions_kosher | attributes_DietaryRestrictions_halal | attributes_DietaryRestrictions_soy-free | attributes_DietaryRestrictions_vegetarian | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Pns2l4eNsfO8kk83dixA6A | Abby Rappoport, LAC, CMQ | 1616 Chapala St, Ste 2 | Santa Barbara | CA | 93101 | 34.426679 | -119.711197 | 5.0 | 7 | 0 | True | Doctors, Traditional Chinese Medicine, Naturopathic/Holistic, Acupuncture, Health & Medical, Nutritionists | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 1 | mpf3x-BjTdTEA3yCZrAYPw | The UPS Store | 87 Grasso Plaza Shopping Center | Affton | MO | 63123 | 38.551126 | -90.335695 | 3.0 | 15 | 1 | NaN | Shipping Centers, Local Services, Notaries, Mailbox Centers, Printing Services | True | 0:0-0:0 | 8:0-18:30 | 8:0-18:30 | 8:0-18:30 | 8:0-18:30 | 8:0-14:0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | tUFrWirKiKi_TAnsVWINQQ | Target | 5255 E Broadway Blvd | Tucson | AZ | 85711 | 32.223236 | -110.880452 | 3.5 | 22 | 0 | False | Department Stores, Shopping, Fashion, Home & Garden, Electronics, Furniture Stores | True | 8:0-22:0 | 8:0-22:0 | 8:0-22:0 | 8:0-22:0 | 8:0-23:0 | 8:0-23:0 | True | 2.0 | False | False | False | False | no | False | False | False | True | False | True | False | False | False | False | False | 8:0-22:0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 3 | MTSW4McQd7CbVtyjqoe9mw | St Honore Pastries | 935 Race St | Philadelphia | PA | 19107 | 39.955505 | -75.155564 | 4.0 | 80 | 1 | False | Restaurants, Food, Bubble Tea, Coffee & Tea, Bakeries | False | 7:0-20:0 | 7:0-20:0 | 7:0-20:0 | 7:0-20:0 | 7:0-21:0 | 7:0-21:0 | True | 1.0 | NaN | True | False | True | free | False | True | False | False | False | NaN | NaN | False | NaN | NaN | NaN | 7:0-21:0 | none | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 4 | mWMc6_wTdE0EUBKIGXDVfA | Perkiomen Valley Brewery | 101 Walnut St | Green Lane | PA | 18054 | 40.338183 | -75.471659 | 4.5 | 13 | 1 | NaN | Brewpubs, Breweries, Food | True | NaN | NaN | 14:0-22:0 | 16:0-22:0 | 12:0-22:0 | 12:0-22:0 | True | NaN | NaN | True | NaN | False | NaN | None | None | None | True | False | True | NaN | NaN | NaN | NaN | NaN | 12:0-18:0 | NaN | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | CF33F8-E6oudUQ46HnavjQ | Sonic Drive-In | 615 S Main St | Ashland City | TN | 37015 | 36.269593 | -87.058943 | 2.0 | 6 | 1 | False | Burgers, Fast Food, Sandwiches, Food, Ice Cream & Frozen Yogurt, Restaurants | True | 0:0-0:0 | 6:0-22:0 | 6:0-22:0 | 6:0-22:0 | 9:0-0:0 | 9:0-22:0 | False | 1.0 | False | True | True | False | no | NaN | NaN | NaN | NaN | NaN | True | False | True | True | False | False | 8:0-22:0 | none | True | casual | False | True | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 6 | n_0UpQx1hsNbnPUSlodU8w | Famous Footwear | 8522 Eager Road, Dierbergs Brentwood Point | Brentwood | MO | 63144 | 38.627695 | -90.340465 | 2.5 | 13 | 1 | NaN | Sporting Goods, Fashion, Shoe Stores, Shopping, Sports Wear, Accessories | True | 0:0-0:0 | 10:0-18:0 | 10:0-18:0 | 10:0-18:0 | 10:0-18:0 | 10:0-18:0 | True | 2.0 | NaN | NaN | NaN | NaN | NaN | False | False | False | True | False | NaN | NaN | NaN | NaN | NaN | NaN | 12:0-18:0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 7 | qkRM_2X51Yqxk3btlwAQIg | Temple Beth-El | 400 Pasadena Ave S | St. Petersburg | FL | 33707 | 27.766590 | -82.732983 | 3.5 | 5 | 1 | NaN | Synagogues, Religious Organizations | NaN | 9:0-17:0 | 9:0-17:0 | 9:0-17:0 | 9:0-17:0 | 9:0-17:0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | k0hlBqXX-Bt0vf1op7Jr1w | Tsevi's Pub And Grill | 8025 Mackenzie Rd | Affton | MO | 63123 | 38.565165 | -90.321087 | 3.0 | 19 | 0 | NaN | Pubs, Restaurants, Italian, Bars, American (Traditional), Nightlife, Greek | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | True | False | True | free | False | False | False | True | False | NaN | NaN | True | True | False | NaN | NaN | full_bar | True | casual | NaN | True | NaN | average | False | False | False | False | False | False | False | False | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 9 | bBDDEgkFA1Otx9Lfe7BZUQ | Sonic Drive-In | 2312 Dickerson Pike | Nashville | TN | 37207 | 36.208102 | -86.768170 | 1.5 | 10 | 1 | False | Ice Cream & Frozen Yogurt, Fast Food, Burgers, Restaurants, Food | True | 0:0-0:0 | 6:0-21:0 | 6:0-21:0 | 6:0-16:0 | 6:0-16:0 | 6:0-17:0 | NaN | 1.0 | False | True | True | False | no | False | False | False | False | False | True | False | True | True | False | False | 6:0-21:0 | none | True | casual | False | False | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| business_id | name | address | city | state | postal_code | latitude | longitude | stars | review_count | is_open | attributes_ByAppointmentOnly | categories | attributes_BusinessAcceptsCreditCards | hours_Monday | hours_Tuesday | hours_Wednesday | hours_Thursday | hours_Friday | hours_Saturday | attributes_BikeParking | attributes_RestaurantsPriceRange2 | attributes_CoatCheck | attributes_RestaurantsTakeOut | attributes_RestaurantsDelivery | attributes_Caters | attributes_WiFi | attributes_BusinessParking_garage | attributes_BusinessParking_street | attributes_BusinessParking_validated | attributes_BusinessParking_lot | attributes_BusinessParking_valet | attributes_WheelchairAccessible | attributes_HappyHour | attributes_OutdoorSeating | attributes_HasTV | attributes_RestaurantsReservations | attributes_DogsAllowed | hours_Sunday | attributes_Alcohol | attributes_GoodForKids | attributes_RestaurantsAttire | attributes_RestaurantsTableService | attributes_RestaurantsGoodForGroups | attributes_DriveThru | attributes_NoiseLevel | attributes_Ambience_romantic | attributes_Ambience_intimate | attributes_Ambience_touristy | attributes_Ambience_hipster | attributes_Ambience_divey | attributes_Ambience_classy | attributes_Ambience_trendy | attributes_Ambience_upscale | attributes_Ambience_casual | attributes_GoodForMeal_dessert | attributes_GoodForMeal_latenight | attributes_GoodForMeal_lunch | attributes_GoodForMeal_dinner | attributes_GoodForMeal_brunch | attributes_GoodForMeal_breakfast | attributes_BusinessAcceptsBitcoin | attributes_Smoking | attributes_Music_dj | attributes_Music_background_music | attributes_Music_no_music | attributes_Music_jukebox | attributes_Music_live | attributes_Music_video | attributes_Music_karaoke | attributes_GoodForDancing | attributes_AcceptsInsurance | attributes_BestNights_monday | attributes_BestNights_tuesday | attributes_BestNights_friday | attributes_BestNights_wednesday | attributes_BestNights_thursday | attributes_BestNights_sunday | attributes_BestNights_saturday | attributes_BYOB | attributes_Corkage | attributes_BYOBCorkage | attributes_HairSpecializesIn_straightperms | attributes_HairSpecializesIn_coloring | attributes_HairSpecializesIn_extensions | attributes_HairSpecializesIn_africanamerican | attributes_HairSpecializesIn_curly | attributes_HairSpecializesIn_kids | attributes_HairSpecializesIn_perms | attributes_HairSpecializesIn_asian | attributes_Open24Hours | attributes_RestaurantsCounterService | attributes_AgesAllowed | attributes_DietaryRestrictions_dairy-free | attributes_DietaryRestrictions_gluten-free | attributes_DietaryRestrictions_vegan | attributes_DietaryRestrictions_kosher | attributes_DietaryRestrictions_halal | attributes_DietaryRestrictions_soy-free | attributes_DietaryRestrictions_vegetarian | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 150336 | WnT9NIzQgLlILjPT0kEcsQ | Adelita Taqueria & Restaurant | 1108 S 9th St | Philadelphia | PA | 19147 | 39.935982 | -75.158665 | 4.5 | 35 | 1 | NaN | Restaurants, Mexican | True | 11:0-22:0 | 11:0-22:0 | NaN | 11:0-22:0 | 11:0-2:0 | 11:0-2:0 | True | 2.0 | NaN | True | True | True | free | None | True | None | False | False | False | False | False | True | False | NaN | 11:0-22:0 | none | True | casual | True | True | NaN | NaN | None | None | None | False | None | None | None | None | True | True | None | True | True | None | None | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 150337 | x_2IrYgFiQn7GOTTgWRbAw | The Vac & Sew Center | 200 Haddonfield Berlin Rd, Ste 5 | Voorhees | NJ | 08043 | 39.857700 | -74.987230 | 4.0 | 5 | 0 | NaN | Appliances & Repair, Home & Garden, Appliances, Local Services, Shopping | NaN | 9:30-18:0 | 9:30-18:0 | 9:30-18:0 | 9:30-18:0 | 9:30-18:0 | 9:30-17:0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 150338 | fn3ybdsRSrIDpKZTsRuAWg | INSPcenter/Thai Clinical Massage | 2625 N Meridian St, Unit 50 | Indianapolis | IN | 46208 | 39.805057 | -86.155975 | 4.0 | 12 | 1 | True | Massage Therapy, Rolfing, Beauty & Spas, Reflexology, Health & Medical, Life Coach, Professional Services, Fitness & Instruction, Meditation Centers, Massage, Reiki, Occupational Therapy, Active Life | True | 10:0-20:0 | 10:0-20:30 | 10:0-20:0 | 10:0-20:0 | 10:0-20:0 | 10:0-20:0 | True | 2.0 | NaN | NaN | NaN | NaN | NaN | False | False | False | True | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 150339 | 2O2K6SXPWv56amqxCECd4w | The Plum Pit | 4405 Pennell Rd | Aston | DE | 19014 | 39.856185 | -75.427725 | 4.5 | 14 | 1 | NaN | Restaurants, Comfort Food, Food, Food Trucks, Caterers, Event Planning & Services | True | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | 0:0-0:0 | True | 1.0 | NaN | True | False | True | NaN | False | True | False | False | False | True | NaN | NaN | NaN | NaN | NaN | 0:0-0:0 | none | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 150340 | hn9Toz3s-Ei3uZPt7esExA | West Side Kebab House | 2470 Guardian Road NW | Edmonton | AB | T5T 1K8 | 53.509649 | -113.675999 | 4.5 | 18 | 0 | NaN | Middle Eastern, Restaurants | NaN | 11:0-22:0 | 11:0-22:0 | 11:0-22:0 | 11:0-22:0 | 11:0-22:0 | 11:0-22:0 | NaN | 2.0 | NaN | True | NaN | NaN | NaN | False | False | False | False | False | NaN | NaN | NaN | NaN | NaN | NaN | 11:0-22:0 | NaN | True | casual | True | True | NaN | average | False | False | False | False | NaN | False | False | False | False | False | False | False | False | False | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 150341 | IUQopTMmYQG-qRtBk-8QnA | Binh's Nails | 3388 Gateway Blvd | Edmonton | AB | T6J 5H2 | 53.468419 | -113.492054 | 3.0 | 13 | 1 | False | Nail Salons, Beauty & Spas | NaN | 10:0-19:30 | 10:0-19:30 | 10:0-19:30 | 10:0-19:30 | 10:0-19:30 | 10:0-17:30 | NaN | 3.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 11:0-17:0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 150342 | c8GjPIOTGVmIemT7j5_SyQ | Wild Birds Unlimited | 2813 Bransford Ave | Nashville | TN | 37204 | 36.115118 | -86.766925 | 4.0 | 5 | 1 | NaN | Pets, Nurseries & Gardening, Pet Stores, Hobby Shops, Bird Shops, Home & Garden, Shopping | True | 9:30-17:30 | 9:30-17:30 | 9:30-17:30 | 9:30-17:30 | 9:30-17:30 | 9:0-17:0 | True | 2.0 | NaN | NaN | NaN | NaN | no | False | False | False | True | False | NaN | NaN | NaN | NaN | NaN | NaN | 0:0-16:0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 150343 | _QAMST-NrQobXduilWEqSw | Claire's Boutique | 6020 E 82nd St, Ste 46 | Indianapolis | IN | 46250 | 39.908707 | -86.065088 | 3.5 | 8 | 1 | NaN | Shopping, Jewelry, Piercing, Toy Stores, Beauty & Spas, Accessories, Fashion | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 1.0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 150344 | mtGm22y5c2UHNXDFAjaPNw | Cyclery & Fitness Center | 2472 Troy Rd | Edwardsville | IL | 62025 | 38.782351 | -89.950558 | 4.0 | 24 | 1 | NaN | Fitness/Exercise Equipment, Eyewear & Opticians, Shopping, Sporting Goods, Bikes | True | 9:0-20:0 | 9:0-20:0 | 9:0-20:0 | 9:0-20:0 | 9:0-20:0 | 9:0-17:0 | True | 4.0 | NaN | None | None | NaN | NaN | False | False | False | True | False | NaN | NaN | NaN | NaN | NaN | NaN | 10:0-17:0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 150345 | jV_XOycEzSlTx-65W906pg | Sic Ink | 238 Apollo Beach Blvd | Apollo beach | FL | 33572 | 27.771002 | -82.394910 | 4.5 | 9 | 1 | False | Beauty & Spas, Permanent Makeup, Piercing, Tattoo | True | NaN | 12:0-19:0 | 12:0-19:0 | 12:0-19:0 | 12:0-19:0 | 12:0-19:0 | False | 1.0 | NaN | NaN | NaN | NaN | free | False | False | False | True | False | True | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | False | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |